How To Write Raw SQL w/ Type Safety in Prisma ORM

This video introduces TypedSQL, a long-awaited feature in Prisma ORM that makes raw SQL queries type-safe. Learn how this new functionality enhances your development experience by providing type safety, auto-completion, and more! Join ‪@marc-hess‬ as he walks through the benefits of TypedSQL and shows you exactly how to implement it in your projects!
TypedSQL: www.prisma.io/...
Blog: pris.ly/typeds...
Docs: pris.ly/d/type...
Example: pris.ly/typeds...
------------------
📚 Learn more about Prisma
• Website: www.prisma.io
• Docs: www.prisma.io/...
• Quickstart: pris.ly/qstart
------------------
👋 Connect with the Prisma Community
• Discord: / discord
• GitHub: www.github.com...
------------------
💬 Follow Prisma on social media
• Twitter: / prisma
• LinkedIn: / prisma-io
------------------
✅ Subscribe to Prisma's KZbin channel
/ @prismadata

[@PrismaData]

Let us know what you think! Will you use TypedSQL in your next project? Get started writing type-safe raw SQL -> pris.ly/d/typedsql

[@intergenredocument]

Thanks for this feature 👏 I think intellisense and option to write inline SQL within TS file would be also great 😌

[@HeyWorld-o8j]

Nope, unless you can solve one feature that will improve security and DX. Don't make us insert the wrong columns when someone unknowingly swpped the columns, please. That's not safe.

[@warrensadler1271]

🤯 kudos to the prisma team for this feature!

[@48265868]

I did not even think it was possible to overcomplicate this basic feature. Yet you actually overcomplicated what should be simple...

[@aghileslounis]

Excellent, it reminds me of "sqlx" in Go. Does Prisma wrapps the RAW sql query in an additional thing, or does it run as it is? What about transactions, can we write them in RAW sql and expect to work correctly?

[@andyheld3136]

I didnt try the feature yet, but in case of transaction you are on the safe side to use the prisma transactuon client.$transaction(async(txClient)=>{txClient.queryRawTyped(q1); txClient.queryRawTyped(q2);})

[@Saru-Dono]

It would be really cool if you could also define them directly in TS code. For example, if you export a string starting with `sqlPrisma` it gets picked up by the Prisma generator and is able to be used(ideally only within the context of the file)

[@최지원-o9o]

In order to use the features shown in the video, the database must be connected at the time of building the Prisma client. This is extremely inconvenient. I hope this will be improved soon so that the client can be built using only the Prisma schema information without the dependency on an actual database connection.

[@oscarresonable2008]

Finally... ❤🎉 Thank you prisma.

[@PrismaData]

Thank you for being a member of the community!

[@notrab]

Great video @marc-hess!

[@BarisPalabiyik]

Great feature to migrate stuff from old repos too.

[@Saru-Dono]

This actually makes me want to go back to Prisma. Looks very impressive, I'm curious about it's limitations. The production quality could be better tho

[@wandenreich770]

Interesting… definately will check this out

[@PrismaData]

Let us know what you think once you do!

[@yassinesafraoui]

Interesting feature honestly, but last time I checked prisma wasn’t the best option for serverless, when is that gonna change?

[@48265868]

waw Prisma support raw SQL in a basic typesafe wrapper? So innovative... Glad it only took 10 years to figure out that it is a bad idea to abstract industri standart SQL.

[@SARFEX]

Woooow🎉

[@codernerd7076]

Wish it had some kind of time zone protection build in so I always get the date and time back in New York time zone or something like that... now it's a mess 😢

[@imsarvesh_]

Amazing..

[@makedredd299]

Where can I find a Prisma GraphQL course in regular JavaScript or NodeJS, that is updated and supported by a person or community? I want to learn how to build a complete GraphQL app without having to learn ReactJS web framework as a prerequisite.