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
I would rather forget everything about Prisma the second I wake up in the morning and have to read their docs on how to do everything all over again, every single day, than try to understand what the heck is going on in SQL's docs.
Most queries you can figure out just from typescript auto complete too...
Majority of queries in an app are basic relationships and crud actions... doesn’t take endless hours figuring this out with prisma.
If it did, we wouldn’t use it.
That is not how this works at all. You don't know what you don't know until you need "how do I do this query in prisma". You then spend an hour trying to figure it out, and maybe it isn't possible, then on to the next thing. It takes more than an hour to learn SQL, so if it takes you an hour to learn Prisma, you are missing something.