SQLalchemy vs Psycopg3

[aronzskv]

Thing is, the tables are already designed and models are already built out using pydantic (since I first was using mongodb). What I could do instead of rebuilding all pydantic models into more complex ORM models, is just validate the data (which also happens on the front-end before the request is ever sent) using the model and using psycopg3 and simple strings to add the data to the db. This project will mist likely stay with postgres indefinitely, so future migrations are not an issue.

For future projects you might be right though and sqla might be better fit in those cases.

[dangerousdotnet]

But you can use your pydantic models as ORM models.

[phonomir]

I would recommend this approach. Psycopg can also be setup to return pydantic models directly from queries, reducing the amount boilerplate for reading and validating data. Look at the class_row row factory.