[Chore] Remove SQLA 2.0 deprecations

[tchapi]

Hi 👋🏼

Following https://github.com/kvesteri/postgresql-audit/issues/62, this is a first pass at removing SQLAlchemy 2.0 deprecations as indicated in the documentation.

Known remaining deprecated parts:

• bind.execute(self.stmt) in StatementExecutor → I don't really see how to address this one. Using the with bind.begin(): stanza is not helping, not sure how to go from here

Note: This is fully 1.4-compatible AFAIK Note²: Running the tests with SQLALCHEMY_WARN_20=1 tox helps finding the offending deprecations

[tchapi]

Great! Thank you for the merge. Any idea on this bind.execute(self.stmt) by any chance?

[jpvanhal]

I think the issue is that StatementExecutor is attempting to create a sub-transaction with tx = bind.begin(). My hunch is that we can remove it since there's already an ongoing transaction.

[tchapi]

My hunch is that we can remove it since there's already an ongoing transaction.

Will try that, thanks for the pointer