ORM Recommendations
Users recommend and compare ORMs and query builders like jOOQ, sqlc, Drizzle, Kysely, and TypeORM, discussing productivity, ergonomics, tradeoffs with raw SQL, and alternatives.
Activity Over Time
Top Contributors
Keywords
Sample Comments
I would suggest looking at jooq. It's a great orm.
What's a better ORM in terms of productivity and ergonomics?
Something like jOOQ?https://www.jooq.org
sqlc is very go-like, i recommend it.
Not sure whether it is an ORM, but some people like JOOQ quite a bit.
Seems very similar to [drizzle](https://orm.drizzle.team/) - although drizzle is a more mature product.
I've found jOOQ to provide the right tradeoffs and flexibilities for ORM vs. SQL. First, it can generate object models of tables from the database in development and therefore doesn't rely on any specific migration tool. These model classes can be used in a conventional ORM fashion, but you also have the option to use jOOQ to build SQL queries.You can even fetch the results of arbitrary SQL expressions into a model class, which can handle partial population of columns. This allows c
I think you should decide if you're aiming for a micro-ORM or a full ORM and explain that in the readme. A full ORM will probably need a lot of features and take a lot of time to develop and stabilize. You can also look at Jooq (not open source) and see if that is what you want to develop.
Or use something next-generation like JooQ.
Very interesting! I do usually prefer using a query builder or raw SQL over an ORM, and will definitely check this one