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