Unable to connect to Cockroachdb using JWT token, enabled in option param

[kcsaff]

Hi, I use cockroachdb, with a connection authenticated by JWT token. My SQLAlchemy/psycopg2 connection string ends in ?options=--crdb:jwt_auth_enabled=true, which works brilliantly, but I'm having trouble translating that into asyncpg-speak. I think in general the FAQ could answer a few questions about how to translate connection string options over from psycopg2.

The main thing I've tried so far is to set different variants of --crdb:jwt_auth_enabled and jwt_auth_enabled to true in connect_args[“server_settings”], but I'm still failing to connect via asyncpg. Presumably this flag needs to be passed a different way.

I have more background over at the CockroachDB forum: https://forum.cockroachlabs.com/t/sqlalchemy-asyncpg-and-jwt/7009

Please let me know if there's something else I should try.