# SQLAlchemy

33 Hacker News commenters recommended SQLAlchemy and 28 criticized it, November 2025 to November 2026. It was recommended in 11 of 13 months.

**Verdict:** Recommended as a flexible Python SQL toolkit and ORM for developers who know SQL. Critics find it complicated and its lazy loading surprising.

## Why people recommend it

- Precise control over generated SQL (5 comments): "Alchemy's strong point is "here's an existing database; let users who grok DB theory query it as efficiently and ergonomically as possible."" ([source](https://news.ycombinator.com/item?id=47405588)) "I am 100% sure what SQL do I want it to produce and what SQL will a particular ORM invocation produce." ([source](https://news.ycombinator.com/item?id=48787681)) "at no point were we married to it, you could generate your query any which way you please" ([source](https://news.ycombinator.com/item?id=50053049))
- Query builder usable without ORM (4 comments): "at no point were we married to it, you could generate your query any which way you please" ([source](https://news.ycombinator.com/item?id=50053049)) "SQLAlchemy has an eDSL of SQL, so you can skip the whole ORM/table mapping layer" ([source](https://news.ycombinator.com/item?id=50232160)) "Yeah, you can use SQLAlchemy like this. It's called the data mapper pattern." ([source](https://news.ycombinator.com/item?id=48792058))
- Capable with a strong toolchain (4 comments): "Alchemy is the greatest thing in the world when you need its exact features." ([source](https://news.ycombinator.com/item?id=46902915)) "SQLAlchemy is undeniably the superior and far more capable ORM" ([source](https://news.ycombinator.com/item?id=46219674)) "sqlalchemy and alembic is a great toolchain outside of django" ([source](https://news.ycombinator.com/item?id=49058346))

## What people warn about

- Complicated API and messy code (4 comments): "kludgy as it tries to translate SQL into a new language" ([source](https://news.ycombinator.com/item?id=46075260)) "I once tried using SqlAlchemy but I couldn't help asking myself why it felt so complicated compared to Django." ([source](https://news.ycombinator.com/item?id=49056906)) "What function signature isn't going to look messy with 36 keyword arguments." ([source](https://news.ycombinator.com/item?id=48454835))
- Lazy loading causes surprises (3 comments): "So many things just don't really work in this world, like old-school lazy fetching in SQLAlchemy." ([source](https://news.ycombinator.com/item?id=48440190)) "undisciplined (in terms of perf and cost) new ORM code being deployed (SQLAlchemy)" ([source](https://news.ycombinator.com/item?id=46099871)) "they're always lazy, so you never really know when the N+1s are going to happen" ([source](https://news.ycombinator.com/item?id=46358339))
- Compared unfavorably with Django's ORM (3 comments): "Lol I never knew django orm is faster than SQLAlchemy. But having used both that makes sense." ([source](https://news.ycombinator.com/item?id=47364542)) "the ORM blows SQLAlchemy out of the water, in terms of being able to produce quality software, quickly" ([source](https://news.ycombinator.com/item?id=46169791)) "I prefer a Django-like ORM to SQLAlchemy in spite of all the praises it gets" ([source](https://news.ycombinator.com/item?id=45938753))
- Plain SQL is simpler (2 comments): "I can guarantee that someone equipped with a good foundation in SQL will be more successful debugging a Sequelize based application, than someone who has relied on SQLAlchemy" ([source](https://news.ycombinator.com/item?id=47111252)) "Every time I use them I think to myself it would be easier to just write SQL myself" ([source](https://news.ycombinator.com/item?id=46925607))

## Alternatives hackers recommend

- [Entity Framework Core](https://hackerapproved.com/p/entity-framework-core.md): 35 recommend
- [Drizzle ORM](https://hackerapproved.com/p/drizzle-orm.md): 25 recommend
- [Dapper](https://hackerapproved.com/p/dapper.md): 19 recommend
- [Oxyde ORM](https://hackerapproved.com/p/oxyde.md): 18 recommend
- [Django ORM](https://hackerapproved.com/p/django-orm.md): 15 recommend

## Cite as

Hacker Approved, "SQLAlchemy", https://hackerapproved.com/p/sqlalchemy/ (counts from 1,795,640 Hacker News comments, November 2025 to November 2026).