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?

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

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

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

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

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

living out of my suitcase, doing stuff onchain, and all about that taste. intern /walletconnect. yapping /tastepod /buenosaires

● granny-JoJo fullstack DEV @ /gnosispay wallet |  prev liquality.io
| contributoor /backpack /addresso

I have tried prisma, drizzle and knexjs. I think Drizzle was my favorite so far! 

for small projects i still think regular SQL is no problem and usually easier

My projects haven't been so complex for very complex queries. 
Prisma still does the job for small projects, I guess.

- Drizzle and Kysely are my go-to favourites right now. Both can handle complex queries as well.
- Sequelize only if I am feeling basic.

🫡