Is there a way to insert an unsafe string into pri...
# orm-helpv
Vasily Zorin
09/18/2022, 10:18 AMIs there a way to insert an unsafe string into prisma.$queryRaw ?
👀 1
r
Raphael Etim
09/19/2022, 4:29 AMHi @Vasily Zorin 👋
Have you considered using queryRawUnsafe? However do note that there are potential security risk with this approach.
v
Vladi Stevanovic
09/22/2022, 7:42 AM
👋 Hello @Vasily Zorin, did you have a chance to see Raphael's message? Let us know if this worked!
v
Vasily Zorin
09/22/2022, 7:45 AMHey! Yeah, I am using queryRawUnsafe, but it doesn’t support ${value}
Vasily Zorin
09/22/2022, 7:47 AMIt would be nice to have something like `$queryRaw`SELECT * FROM table AS OF SYSTEM TIME ${Prisma.raw('…')} WHERE foo = ${bar}``
👍 1
🤔 1
Vasily Zorin
09/22/2022, 7:48 AM@Vladi Stevanovic
r
Raphael Etim
09/22/2022, 7:50 AMThanks @Vasily Zorin for letting us know. For your specific use case, can you please open a feature request.
3 Views