Backend

Prisma and I have broken up. 
1) It can't handle complex queries
2) Most issues have been flagged by the team, but unresolved for years
3) The team prioritizes feature releases over fixes

Any other ORMs I should look at?

design @splits | /latenightcrew /event-pass /feud

building @so many products • prev. @everyname (acq) @nethermind @proximacapital @consensysacad • thomphreys.com

Drizzle is probably the best option although I think @matthew is a Kysely fan, might be worth a look as well

Drizzle seems to be the community favorite at this point + their team ships very fast

/new-york by day 🗽 /latenightcrew by night :) Fan of eating tacos and bringing people together, often at the same time 🌮 oh and /untzuntz 😈

going to check out drizzle! I have kysely running with neynar hosted db, but I'm not that good at sql so it's tough to write complex queries.

and yeah prisma is not great for this and "relations" in prisma aren't nearly as powerful as a sql wrapper like kysely

Nah, have only tried Prisma and Drizzle (and Mongoose awhile back but that’s a different story)

Not the biggest database junkie so generally just try to use whatever tool is easy and gets the job done (fan of Prisma for this reason but I understand that it has its drawbacks)

Kysely looks nice – lightweight is definitely a bonus! Have you used Knex.js much?