Raw query in Prisma Query Console
I'm trying to run a raw query in the Prisma Query Console of the Data Platform.
The line
await prisma.$queryRaw(Prisma.sql`SELECT * FROM "public"."User";`)
Returns a PrismaClientUnknownRequestError error with the message
$queryRawis a tag function, please use it like the following:
const result = await prisma.$queryRaw`SELECT * FROM User WHERE id = ${1} OR email = ${'[email protected]'};
Or read our docs at https://www.prisma.io/docs/concepts/components/prisma-client/raw-database-access#queryraw
If instead I replace it by the following as suggested by the message
await prisma.$queryRaw`SELECT * FROM "public"."User";`
The code is greyed and the execute button is disabled so I can't run the query.
How can I run raw queries in the Query Console?
As of now (nov. 2022) this is a known limitation of the Query Console. Here is the answer from Prisma support:
The format of
$queryRawwithout parenthesis isn't supported yet, due to which the execution is disabled. The error that is returned suggests defining variables and passing them in $queryRaw in tagged literal format, as of now defining variables in Query Console isn't supported either. Our product team is aware of this limitation, and we do plan to address this.
The workaround is to use $queryRawUnsafe. The syntax is
await prisma.$queryRawUnsafe('SELECT * FROM "public"."User"')
- Prisma openssl version issue
- Prisma how can I update only some of the models fields in update()
- TypeError while running a database seeding script in Next.js, Prisma ORM
- get full type on prisma client
- Reason: `object` ("[object Date]") cannot be serialized as JSON. Please only return JSON serializable data types
- "Next.js TypeScript error: 'param_type.params' incompatible with 'ParamCheck<RouteContext>' during build"
- prisma - getting environment variable not found error message when running graphql query
- Fetching Next.js API Route in the app directory gives 404 Not Found
- PrismaClientValidationError Invalid `prisma.ticket.create()` invocation
- How can I put my variable inside Axios and send it to my database?
- How do I return an image from my sveltekit api to the client?
- How to get Prisma client to generate relationship types
- How to upsert new record in Prisma without an ID?
- @prisma/client did not initialize yet. Please run "prisma generate" and try to import it again
- The right way to create an auto increment ID on Prisma using mongodb
- next-auth credentials provider authorize type error
- Prisma find many and count in one request
- Seeding with prisma nested create with one-to-one relation
- prisma Error: p1001: Can't reach database server at `db.xocheossqzkirwnhzxxm.supabase.co`:`5432`
- Filter by ObjectId with equals operator in $search pipeline stage does not work
- TypeError: The "payload" argument must be of type object. Received null
- Using a prisma query with callback seems to ignore try/catch blocks (Node)
- How can I insert a dynamically-chosen raw SQL clause when using prisma.$queryRaw as a template literal tag?
- the created_at search in prisma aggregateRow mongodb does not work
- Prisma query engine not found on mac M1
- Prisma: Error validating datasource `db`: the URL must start with the protocol `postgresql://` or `postgres://`
- Unknown binaryTarget debian-openssl-3.0.x and no custom binaries were provided error Command failed with exit code 1
- When use two argument or more with where get error
- Apply Prisma Migrations to Multiple Environments with Kubernetes
- prisma - make a field equal to another when it is created