google / sqlcommenter

Apache License 2.0
601 stars 81 forks source link

feat(support): support JOOQ for Java/Kotlin/Scala #40

Open davinkevin opened 3 years ago

davinkevin commented 3 years ago

Hi,

First, I would thank you for open sourcing this library and releasing features around SQL performance and analysis, which is from my point of view, this is very important 🔥.

I would like to ask/propose SQLCommenter to support a really famous and important library of the JVM world named JOOQ. As a Google Developer Expert on Google Cloud and Kotlin, I see a lot of interest on this library, to perform better queries and be able to optimize/analyse requests made to our SQL engine.

I know SQLCommenter is still young, but I open this issue to allow people to do a 👍 if they think this should be a good idea to support this too.

If you are open to PR, I'll be glad to propose something if you want.

Thanks

lukaseder commented 3 years ago

Some implementation hints can be found here: https://github.com/jOOQ/jOOQ/issues/11335#issuecomment-908312211

This is best solved using an ExecuteListener, see: https://www.jooq.org/doc/latest/manual/sql-execution/execute-listeners/