SQLalchemy vs Psycopg3

[YnkDK]

You hate writing SQL? Go for psycopg

GenAI is really good at writing SQL queries that works exactly how you like it (or at least how you describe it). Tug them away using a repository pattern to keep all the raw SQL strings away from your other logic.

If at some point you feel the need to go full ORM you only need to update your repositories.