Query builder to run alongside Prisma

[KarolScibior]

Hey,

I come from MikroORM and I'm loving Prisma so far, but lack of any query builder and no plans to create one really makes me think about going back.

Has anyone used any additional type-safe query builder libraries alongside Prisma to somehow tackle this issue? Like a query builder that would take a type generated by Prisma Client and would somehow let me create a query to run on that DB.

I'm gonna try kysely with prisma-kysely, but maybe someone has a better alternatives?

[nurul3101]

Hello @KarolScibior 👋

We do have a feature request for adding support for a native query builder:

• Using Prisma Client as query builder only and get the SQL queries like prisma.user.findOne().getRawQuery() #5052

If you can add a 👍 to the feature request, then it would help our product team in prioritising it.

I have seen users using Knex in conjunction with Prisma, but I believe kysely would be a good alternative as it has better typescript support.

[nikolasburk]

To add to Nurul's answer:

This tool isn't really a query builder but it still substantially improves the workflow when working with raw queries in Prisma: https://safeql.dev/compatibility/prisma.html We just had the author on What's new in Prisma yesterday in case you're interested in learning some more about the tool 😄

Otherwise, we have some additional open issues for this functionality where it would be helpful if you could leave a 👍 and a comment with your use case to help us prioritize these in the future 🙂

• whereRaw model query option for Prisma Client queries #5560
• raw SQL expressions #12279
• Ability to daisy chain queries - To allow minimal raw queries within the daisy chain via .raw() - e.g. GIS Support #6689
• Access to raw sql functions using Prisma APIs. #5761

[danil-iglu]

@KarolScibior will this do the trick?
https://www.npmjs.com/package/prisma-query-builder-ui