3 ms·
I would recommend to use just good old database client and send your queries as text, nothing it's easier than that, every orm struggles when you want to do som
by norman784 3y ago
I would recommend to use just good old database client and send your queries as text, nothing it's easier than that, every orm struggles when you want to do some relatively complex query, I struggled to do something like this with kysely `LEFT JOIN table2 ON (table1.id = tabl2.id AND table2.status = 1` was insane how complicated it was, sure you can pass raw sql, but what's the point of the orm then.
- belmont_sup 3y agoHaving the simple CRUD apis for a table/model is super helpful though. I use prisma, and then when it becomes too complex, or is annoying, switch to sql. Sometimes I don’t want to have to manually deserialize rows into my objects (and yes, orms do this for us, and some non-orms do too).