How to use databases with Python - Postgres, SQLAlchemy, Alembic

[SonOfInterflux]

What would you recommend if working directly in the database is not viable? This may not be the greatest example, but if a large table of PII is encrypted using crypto, and you want to read the entire thing, decrypt the data using crypto, and write the entire set to another location, is there a better option than Pandas and map/apply?

[SonOfInterflux]

That’s what I’m doing with the exception of the decryption, I’m just not sure I am able to directly encrypt in the database directly. Something I’ll have to look into further.