Hi Any update on prisma supporting SQL functions like GROUP_CONCAT, FIND_IN_SET etc?

Hey Keshav 👋 We don’t have any updates at the moment, you would need to use Raw Query for now. We have a feature request for supporting advanced SQL functions: #3996 Please feel free to add a 👍 to the request and subscribing to the request to get latest updates.

Hi Nurul, thanks for the update. What about Joins ? I suppose LEFT, RIGHT, OUTER Joins etc are not supported by prisma yet ? am I correct ? If so what is the possible time roadmap prisma team is planning to incorporate the joins ?

Prisma offers an abstraction over JOINs via its

include

option, so you could use include to achieve joins.

include is equivalent for INNER Join I suppose. What about LEFT, RIGHT and OUTER ?

For those you would need to use queryRaw for now.