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.

📉 Falling 0.3x Databases
3,481
Comments
20
Years Active
5
Top Authors
#3961
Topic ID

Activity Over Time

2007
5
2008
8
2009
25
2010
37
2011
56
2012
66
2013
166
2014
168
2015
164
2016
189
2017
207
2018
155
2019
285
2020
333
2021
394
2022
250
2023
448
2024
303
2025
217
2026
5

Keywords

postgres.js JS ON tinspin.itch create.sql typeorm.io LEFT JPA post.id SQL orm sql query queries builder sql queries orms postgres database builders

Sample Comments

4RealFreedom Jun 7, 2023 View on HN

I would suggest looking at jooq. It's a great orm.

CharlieDigital Dec 16, 2025 View on HN

What's a better ORM in terms of productivity and ergonomics?

noisem4ker Sep 21, 2019 View on HN

Something like jOOQ?https://www.jooq.org

philosopher1234 Jul 15, 2022 View on HN

sqlc is very go-like, i recommend it.

kaba0 Sep 19, 2022 View on HN

Not sure whether it is an ORM, but some people like JOOQ quite a bit.

rohan_ Dec 6, 2024 View on HN

Seems very similar to [drizzle](https://orm.drizzle.team/) - although drizzle is a more mature product.

hagy Apr 12, 2021 View on HN

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

jbergens Dec 15, 2014 View on HN

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.

PaulHoule Nov 13, 2025 View on HN

Or use something next-generation like JooQ.

CraftThatBlock Mar 31, 2020 View on HN

Very interesting! I do usually prefer using a query builder or raw SQL over an ORM, and will definitely check this one