Add support for psycopg

[enocom]

This is a mirror issue of GoogleCloudPlatform/cloud-sql-python-connector#214.

[enocom]

We can port GoogleCloudPlatform/cloud-sql-python-connector#1311 here.

[VIKTORVAV99]

Any update on this?
Would love to try out AlloyDB but all our python code use psycopg and this would make my life a lot easier.

[enocom]

None presently, but we know this is a big hurdle for the Python community using AlloyDB.

I was hoping the PR above would have gotten merged by now. Perhaps we could try to land an adaptation of it here first.