I am currently researching how to build typesafe SQL queries in order to develop a Jira Server App and guarantee it to work on all supported databases. One approach is the jooq (https://www.jooq.org) library using the SQL translation feature from one dialect to another (https://www.jooq.org/translate/), however it’s necessary to buy the professional edition for developers. I did test this approach and it worked nice in open source databases such as MySQL and Postgres in Jira.
So, I would like to discuss and hear from you if there is another approach instead of jooq for building complex and typesafe SQL queries. Maybe jooq is the best option so far.
Thank you’ll =)