Rotating Database Passwords

[mdegis]

I would like to manage rotating password for database connection.

In SQLAlchemy, create_engine method supports the argument creator and I can do something like this:

create_engine('postgresql://', creator=lambda: psycopg2.connect(make_dsn_string()))

(inside make_dsn_string method, I am calling AWS secret manager but it does not matter)

Is there a creator equivalent in databases? or should I implement it by myself (open to any suggestion)?