Use c3p0 initsql to run query on connection creation

I'm hoping to get some guidance on if it possible to create a plugin to use c3p0's initSql feature to run query on creating connection, [example] ( I saw that a ConnectionCustomizer DbActivityTracker was created for this use case but not 100% sure how this can be done in a plugin setup.

I'm hoping to automate initial query for the more junior/less technical members while using duckdb to initialize some duckdb extensions and configs. But also curious how this could be done beyond the duckdb scope as well.


I would use something like pgpool or similar