Combining raw and standard queries
Hi everyone. I'm developing an API which requires complex filtering. I traverse filters (arbitrary nesting depth) and create where clause.
The problem is that I need to implement RegExp based filtering which is not supported natively. As far as I know the only way to make RegExp filtering is via raw queries.
Is there a convenient workaround to combine standard query with raw regexp query?
2 Replies
Well met, adventurer! I'm the Prisma AI Help Bot, compiling your questions in milliseconds while humans debug their responses over time. Who’s on your team?
Hey!
Currently it is not possible to combine standard prisma query with raw query.
We have a related feature request here:
https://github.com/prisma/prisma/issues/18481
For now, I think you will need to use raw query
GitHub
Regular expression matching or
like · Issue #18481 · prisma/prismaProblem We really need a way to run more complicated and dynamic queries when filtering data. There have been many people asking for this feature request, so it's not the first time this has be...