What GraphQL schema to SQL ORM does Prisma use int...
# orm-help
b
What GraphQL schema to SQL ORM does Prisma use internal? custom or something like sequelize or join monster. Specifically wondering about SQL parameter binding and if its done to ensure db can cache queries for performance (which join monster does not do)
n
Prisma is the layer between the DB and GraphQL.
b
right, I meant internally does Prisma us its own or some other SQL builder? And wanted confirmation it does SQL paramater binding using sql with ? and then binding those dynamic parameters, so it uses prepared statements basically ... this is commong Relational DB lingo for allowing caching query plans on sql if u use same sql a lot but for different variables
I just wanted to confirm, most ORMs or sql builders do this, but I was looking at join-monster for graphql to sql and it does NOT, so wanted to confirm
n
Prisma uses prepared statements where possible. Note that it's not always possible to use prepared statements because of the dynamic nature of the Prisma datamodel. SQL queries are generated by the Prisma SQL connector, using Sangria and Slick under the hood. You can check the code on Github 🙂
👍 1