Update to Python 3.12 and add support for Psycopg3

[wlorenzetti]

Update pipenv to Python 3.12. Add support for Psycopg3.

[thorntonedgar]

@palewire can we get this merged?

[davidszotten]

unfortunately i don't think this pr would work as is, it's still importing from e.g. psycopg2.extensions

[palewire]

I'm open to merging and releasing this change. Sorry for having been MIA.

Assuming it works with the new version, my main concern is backwards compatibility. Would this introduce any issues there?

I'd also like to see the try/except logic in the current draft swapped for something more Pythonic, like a hasattr check for the methods that indicate what version is in operation.

[palewire]

And, not to be a pain, but would there be a way to introduce a test that verifies both versions are working?

[davidszotten]

i pushed my stab at this from a few weeks ago in #213

[palewire]

This got handled in #213