Did Prisma.raw and Prisma.sql helpers get removed?

I'm working on writing a new extension. In my code, I use the

.raw

.raw

and

.sql

.sql

helpers/methods. For example

query = Prisma.raw(`${query1}${query2}`)

query = Prisma.raw(`${query1}${query2}`)

. For Prisma 5.14 this works fine, but not in 5.15.1. I initially found it while updating lint, so thought the

Property 'raw' does not exist on type 'typeof Prisma'.

Property 'raw' does not exist on type 'typeof Prisma'.

error I'm seeing in the IDE may have just been cruft. But, in fact, when testing in a real client, it no longer works:

Error: Prisma.raw is not a function

Error: Prisma.raw is not a function

. This usage is still in the documentation: https://www.prisma.io/docs/orm/prisma-client/queries/raw-database-access/raw-queries#building-raw-queries-elsewhere-or-in-stages so I assume it's still supposed to be there. Do I need to change something? Is it a bug?

Learn how you can send raw SQL and MongoDB queries to your database using the raw() methods from the Prisma Client API.

Prisma•2y ago•

4 replies

I'm working on writing a new extension. In my code, I use the

.raw

.raw

and

.sql

.sql

helpers/methods. For example

query = Prisma.raw(`${query1}${query2}`)

query = Prisma.raw(`${query1}${query2}`)

. For Prisma 5.14 this works fine, but not in 5.15.1. I initially found it while updating lint, so thought the

Property 'raw' does not exist on type 'typeof Prisma'.

Property 'raw' does not exist on type 'typeof Prisma'.

error I'm seeing in the IDE may have just been cruft. But, in fact, when testing in a real client, it no longer works:

Error: Prisma.raw is not a function

Error: Prisma.raw is not a function

Learn how you can send raw SQL and MongoDB queries to your database using the raw() methods from the Prisma Client API.