Add support for asyncpg driver

[jackwotherspoon]

Feature Description

Now that Connection pooling is supported with asyncpg and SQLAlchemy, we should support it as a driver with this library.

Sample code

No response

Alternatives Considered

No response

Additional Details

No response

[jackwotherspoon]

While asyncpg is not yet supported by the AlloyDB Python Connector, samples showcasing how to connect to AlloyDB using asyncpg without this library (native asyncpg connection pool, SQLAlchemy pool samples) have been added as part of #121

[enocom]

Related to GoogleCloudPlatform/cloud-sql-python-connector#792.

[kurtisvg]

This feature is necessary for fully supporting AlloyDB in the Database Query Extension repo and our WIP LangChain integrations.

[RahulDubey391]

Hi @enocom , @jackwotherspoon if it's okay can I work on this issue? Since the same is implemented for Cloud SQL Python Connector, I can use it as a reference.

[jackwotherspoon]

if it's okay can I work on this issue? Since the same is implemented for Cloud SQL Python Connector, I can use it as a reference.

Hi @RahulDubey391, thanks for the interest here 😄

This issue is currently blocked by MagicStack/asyncpg#1054

We are going to be working on a PR to asyncpg in order to try and resolve it this week. I will update this issue when work is unblocked and see if you are still interested. 👍

[RahulDubey391]

Thanks @jackwotherspoon for letting me know. Sure I'll look into it once it's unblocked!