As someone who uses both prisma and knex (so something like kysely): Prisma is very very nice, it has maybe the best DX out there. My issue with it is performa

As someone who uses both prisma and knex (so something like kysely): Prisma is very very nice, it has maybe the best DX out there. My issue with it is performance. It is much slower than query builders or raw sql. It's also a huge black box, although I haven't had any issues, you're dealing with a complex beast. Knex (and other query builders) is nicer than raw sql, has good performance, and it's fairly transparent (it's not a 800 pound gorilla like Prisma)