Support for psycopg3

[c-w]

With the release of Django 4.2, there's now official support for psycopg3 in Django and psycopg2 will eventually be deprecated (see release notes).

The use of psycopg2 seems pretty well encapsulated in this library so I wonder if there's a desire to also support the new psycopg3? I can work on a pull request for this if required.

[jimfunk]

Yes, psycopg 3.x is probably a good idea. I have been using it in other, non-Django projects.

If you wanted to take a stab at it, go ahead. I should be able to get it going myself, but it probably won't be in the next couple of weeks.

[c-w]

Great, thank you. As a conversation starter, I opened a pull request which passes the tests on my machine. Looking forward to your inputs!

[jimfunk]

Thanks for the PR.