What are the advantages and disadvantages of using sqlalchemy over psycopg2?

Question

Python

I am writing a small project, I don’t know what to choose between, on the one hand, psycopg2 is quite readable in code and more understandable to me, on the other hand, sqlalchemy is a more general version of communicating with the database, but less understandable to me. I would like to know the advantages and disadvantages of each of the
PS options, as far as I understand in terms of performance, the difference is not great, since psycopg is a database driver and sqlalchemy still accesses it to work with the PSS database in the database,
I only need CRUD

Answer 1

For learning - first use a pure driver, and then alchemy
Try to write code in a clean one, so as not to do sqlinj

Answer 2

You are wrong about performance, ORM will always be slower than queries. And ORM will never be as flexible. But then ORM isolates you from the specifics of specific DBMS, and your project can move from MySQL to PostgreSQL without changes, if necessary. In addition, ORM is easier to work with and it is possible to find errors by static analysis.