I’ve had to write complicated queries with prisma.

In fact. One that prisma didn’t support.

Ordering by the count of a relationship, and returning the few highest counts.

So I added a GitHub issue that is being tracked.

And what did I do for now?

I wrote the SQL using prisma’ raw query function.

You can learn SQL and use an ORM.

Things don’t always have to be one vs the other