Hey Prisma Team, Do you why does prisma rawquery not work when I'm passing a variable. This wokrs if the variable is a number, but anything inside quotes is not working. Example from docs

const email = '<mailto:emelie@prisma.io|emelie@prisma.io>'
const result = await prisma.$queryRaw`SELECT * FROM User WHERE email = ${email}`

This would not work as

email

is enclosed in qoutes. It would work if

const email = 2

for example DB : mySql

Hi @Hussam Khatib 👋 You can try writing it like this

const email = '<mailto:emelie@prisma.io|emelie@prisma.io>'
const result = await prisma.$queryRaw`SELECT * FROM "User" WHERE email = ${email}`

What difference does this make I am still not able to pass by variable

If i understand correctly, you want to pass email as a string variable using query raw

Yes, that example was only demonstration purpose as it was in docs. The issue variable which is passed as string does not work, this worked for when I used intergers

I just tested this code in my local

const email = '<mailto:emelie@prisma.io|emelie@prisma.io>'
const result = await prisma.$queryRaw`SELECT * FROM "User" WHERE email = ${email}`
console.log(result)

The email was parsed correctly and it returned the result

raphael@Raphaels-MBP prisma-graphql % node src/script.js
prisma:query SELECT * FROM "User" WHERE id = $1
[ { email: '<mailto:test@test.com|test@test.com>', id: 2 } ]