Hi, I’m late to reply, but when facing this issue, I decided to build a DSL with a fluent API, similar to jOOQ, on QueryDSL, with Java, but it could easily be used with Groovy. Have a look: https://github.com/reinoutkorbee/NativeQueryDSL. I use it in production, but it is not complete. It is a simple SQL generator, based on Query DSL. Otherwise, have a look at Query DSL. It is fully open source: http://www.querydsl.com/ I developed the SQL generator because I wanted to use a DSL where Hibernate or JPA would produce sub-optimal SQL.
From: mg...@arscreat.com <mg...@arscreat.com> Sent: Monday, October 22, 2018 5:46 PM To: pa...@asert.com.au Cc: dev@groovy.apache.org Subject: Re: High Level DSL for Database Querying When I evaluated what to base my framework on, I did not find much that was available and looked interesting, except jOOQ - which at the time started steering away from being pure OS (so was a no go for us). The jOOQ webpage licensing FAQ has the following to say on the topic: Can I use "jOOQ Open Source Edition" also in commercial software? A: Yes, as any Apache-licensed software, jOOQ can be used in commercial software. Q: Can I use "jOOQ Open Source Edition" also with commercial databases? A: It is unlikely that you will get the "jOOQ Open Source Edition" to work properly with a commercial database that is not supported by the "jOOQ Open Source Edition". We strongly suggest purchasing commercial licenses. Cheers, mg This e-mail message contains confidential information and is intended only for the named recipient(s). If you are not an intended recipient, any disclosure, copying or distribution is prohibited. Please notify the sender immediately by e-mail if you have received this message in error and delete this message from your system. As internet communications are not secure, the Swiss National Bank accepts no liability for any errors or omissions in the contents of this message. Any views expressed in this message are those of the individual sender, except where the sender specifically states them to be the views of the Swiss National Bank.
smime.p7s
Description: S/MIME Cryptographic Signature
