Support for psycopg3?

Has there been any discussion around support for psycopg 3 (now just psycopg)? It is a complete rewrite of the project. It was implemented to support async from the start. Seems like a natural fit.

[rafalp]

PR adding psycopg3 is welcome :)

[tarsil]

This PR does the move to SQLA2 and supports the new psycopg :)

Does it?

[tarsil]

The latest version of databases comes with the latest psycopg

https://github.com/encode/databases/blob/master/databases/core.py

I don't think so.