Init function run on each connection?

USER CASE
Currently for every query I need to do something like below

        async with in_transaction("default") as conn:
            await conn.execute_script(f"SET LOCAL app.some_id = 'abc';")
            # rest of queries after this; e.g. await User.all()

IDEAL SOLUTION
A hook or similar, allowing to run some initial setup when a new connection is created. Or some documentation on how to properly override the "connection manager".

THINGS TRIED
Overriding QuerySet but that doesn't seem to have access to connection directly? Feels maybe not the right place.

I've also tried to monkey-patch the connection handlers but had little success..

# Monkey-patch Tortoise's ConnectionHandler for custom connection init setup
class CustomConnectionHandler(ConnectionHandler):
    def _create_connection(self, conn_alias):
        conn = super()._create_connection(conn_alias)
        
        # Never gets here ..
        
        return conn
tortoise.connection.connections = CustomConnectionHandler()

Start by tracing the connection lifecycle around ConnectionHandler and the in_transaction usage described in the issue; compare that with the QuerySet and monkey-patching approaches already tried. A complete change would provide a supported connection-initialization hook or clear documentation for overriding the connection manager, with coverage showing setup runs when a new connection is created.