3 ms·
How do you do typed raw queries?
by vvpan 1y ago
How do you do typed raw queries?
- campbellmorgan 1y agohttps://www.prisma.io/docs/orm/prisma-client/using-raw-sql/raw-queries https://www.prisma.io/docs/orm/prisma-client/using-raw-sql/r... - it assumes that these queries return arrays and there's a template you can pass in like this: prisma.$queryraw<YourType>`SELECT * FROM ...`
- vvpan 1y agoOh, just manual template typing. That's not great. We've done that and it is error-prone. A SQL-generator infers the types from the query, for example.
- Tadpole9181 1y agoThat's the raw, raw querying. They provide a TypedSQL system where you write SQL and it automatically generated the parameter and return types. It's in the docs.
- seer 1y agoCheck out the docs https://www.prisma.io/docs/orm/prisma-client/using-raw-sql/typedsql https://www.prisma.io/docs/orm/prisma-client/using-raw-sql/t... it generates output types, though input types still need to be done by you via type comments in the sql