[plant-ian]

SQLAlchemy: "SQLAlchemy is the Python SQL toolkit and Object Relational Mapper that gives application developers the full power and flexibility of SQL."

  - connection pooling, multiple drivers
  - core layer (can use to build sql without orm, describe table metadata, output ddl, etc.)
  - orm layer (automatic class to table mapping, relationships, configurable relationship loading strategies, easy ad-hoc optimization of loading objects, write custom SQL to load objects, load relationships from subqueries, etc.)
  - db reflection
  - db inspection
  - migrations (via alembic)
  - now supports async drivers
  - 2.0 coming out soon with more consistent interfaces

Pretty much does almost everything or provides a compatible way for you to do it yourself. I think most people complaining about ORMs just haven't used this one. You still have to know SQL.

edited: formatting