Type-Safe Raw SQL With Prisma

[@bgdnsr]

welcome back Ryan

[@tambourinedmb]

Good feature, but it is not composable (use one query as subquery or share pieces of queries) or modifiable with code like a true query builder would be. I am using knex with prisma raw query functionality. I believe drizzle has the right approach.

[@PrismaData]

thanks for your feedback! the problem space for this feature isn't so much targeted as a full query builder but rather a way to retain the benefits of type information for the times when you need to drop down to raw SQL, especially those cases where you have a standalone script.

[@tambourinedmb]

@ understood it would be very useful. sometimes queries share subqueries or you want to run a count query separately. type safety is nice but a lot of copy/paste. definitely a step in the right direction

[@rli09]

"it's serverless, no coldstart", can u hear what urself just said?

[@hooman1439]

Can you explain that?

[@rli09]

@ how do u have zero coldstart if you’re running serverless functions? Who’s handling the request?

[@hooman1439]

@@rli09 thanks for the answer

[@최지원-o9o]

type safe, but real db connection required when build prisma client haha