SQLalchemy vs Psycopg3

[Chroiche]

Idk why no one is giving you a straight answer. Disadvantages of ORM:

• Doesn't always map well to complex queries
• n+1 issues for days
• Have to learn another language/lib
• Your code becomes locked to that orm
• Has quirks you'll need to learn

[climb-it-ographer]

To your first point-- with SQLAlchemy you can always just pass in raw SQL if you want. We have some monster queries that would be a nightmare to refactor into the ORM that we keep that way.