Everything you need to know about SQLAlchemy

Avoid it at any cost!

Unfortunately, today I thought of using Flask + this beautiful ORM for one of my pet projects. That was a mistake.

Avoid SQLAlchemy and its twin brothers—SQLModel, PonyORM, and the rest. There's no decent ORM in Python except for Django’s ORM. Everything else is half-baked. So, it's really better to implement your own SQL ORM, or just use plain SQL queries.

An ORM should abstract away database management without you needing to worry about it—no need to manually open sessions, commit, update, or whatever.

It should "just work," like in Django or Rails.