+1 for using DSL constructs that are vendor agnostic. Checkout https://github.com/querydsl/querydsl (Apache licensed) as well in-case it fits better in terms of implementation.
Also, once the DSL work is done, please test and document the behavior (exactly once, at-least once ..)the operator has with different databases. Thanks, Dev On Wed, Jul 20, 2016 at 4:04 AM, Bhupesh Chawda <[email protected]> wrote: > It is a good idea to get rid of vendor specific implementation differences > for SQL. > > However, the licensing does not seem to be straightforward. Please check: > http://www.jooq.org/legal/licensing. Can this be used as a dependency in > Apex? > > ~ Bhupesh > > On Wed, Jul 20, 2016 at 3:06 AM, Priyanka Gugale <[email protected]> > wrote: > > > Hi, > > > > Malhar JDBC operator does lots of string manipulation and other handling > to > > construct sql queries as per user inputs. Instead of constructing queries > > on our own we should use some dsl api library which will let us write DB > > agnostic code and take care of all other complexities. > > > > I am trying out JOOQ library to write sql query in > > AbstractJdbcPollInputOperator. Would like to hear about communities > > feedback and suggestions. > > > > -Priyanka > > >
