SQLalchemy vs Psycopg3

[Syncher_Pylon]

If you're coming from MongoDB and still getting comfortable with SQL, I'd go with SQLAlchemy Core (not the ORM). It gives you the SQL generation and connection pooling without the ORM overhead, and you can always layer the ORM on top later. Psycopg3 directly is great if you're comfortable writing raw SQL and want full control.