As jOOQ's API is growing with new functionality and new vendor-specific SQL extensions support, using the API becomes more and more challenging. In order to handle compatibility among various databases, I had added the org.jooq.Support annotation in release 2.0.2. The purpose of this annotation is to document all the SQL dialects supporting any given SQL clause / function. See more details here: - http://www.jooq.org/javadoc/latest/org/jooq/Support.html
Now, in the course of this GitHub issue here: - https://github.com/jOOQ/jOOQ/issues/18 ...the current strategy was reviewed and aligned with an idea that I had previously mentioned on this user group. It would be nice if a user using Oracle and MySQL could pre-process the jOOQ source code using a dedicated Maven plugin, deprecating all API elements that are not supported by both Oracle and MySQL. This would then lead to the intersection of all API subsets that are available in either database. Of course, this is also useful for users using only one database, or more than two databases with jOOQ. This idea was previously discussed here: - https://sourceforge.net/apps/trac/jooq/ticket/1027 - https://groups.google.com/forum/#!topic/jooq-user/wJj9T-rlqy4 Not being a Maven expert, I wonder if anyone on this group would be interested to implement such a preprocessor as a Maven plugin.
