On Wed, Jul 1, 2015 at 8:07 PM, Ole Ersoy <ole.er...@gmail.com> wrote: > Just curious...would this be similar to JOOQ? > > http://www.jooq.org/ > > Cheers, > - Ole
Yes. Something similar. We just need to generate SQL string. > > > On 07/01/2015 10:21 AM, Adrian Crum wrote: >> >> You can make the builder support generic SQL 2003, and provide a way to >> extend the builder with vendor-specific grammar. >> >> Adrian Crum >> Sandglass Software >> www.sandglass-software.com >> >> On 6/30/2015 11:10 PM, Benedikt Ritter wrote: >>> >>> Hello Mansour, >>> >>> 2015-06-30 23:57 GMT+02:00 Mansour Al Akeel <mansour.alak...@gmail.com>: >>> >>>> I am not sure if this is the right place to suggest this. Please let >>>> me know, before filling a Jira Ticket. >>>> I believe DbUtils has place for additional component: >>>> >>>> - A fluent API to generate SQL string: >>>> >>>> Developers find it difficult to concatenate strings to build a query. >>>> A fluent API makes it relatively easier, and keeps the query vendor >>>> independent. >>>> Some of the examples: >>>> * http://iciql.com/ >>>> * http://jodd.org/doc/db/sqlgenerator.html >>>> * http://jdbi.org/ >>>> * Jooq >>>> * https://mybatis.github.io/mybatis-3/statement-builders.html >>>> >>>> I am not talking about the mapping part. I am only suggesting >>>> generating the SQL string builder functionality. Something similar to >>>> MyBatis: >>>> >>>> String sql = new SQL() >>>> .INSERT_INTO("PERSON") >>>> .VALUES("ID, FIRST_NAME", "${id}, ${firstName}") >>>> .VALUES("LAST_NAME", "${lastName}") >>>> .toString(); >>>> >>>> I am wondering how much effort this can be, and most important if >>>> thers's interest in the community to create a separate independent >>>> component just for Sql String generation. MyBatis is under ASL 2.0 >>>> license. >>>> >>>> Anyone else think there's a place in DBUtils for this functionaity ? >>>> >>> >>> That's kind of a domain specific StringBuilder for SQL, right? >>> How would you handle different data base dialects? >>> >>> Benedikt >>> >>> >>>> >>>> Thank you. >>>> >>>> --------------------------------------------------------------------- >>>> To unsubscribe, e-mail: dev-unsubscr...@commons.apache.org >>>> For additional commands, e-mail: dev-h...@commons.apache.org >>>> >>>> >>> >>> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: dev-unsubscr...@commons.apache.org >> For additional commands, e-mail: dev-h...@commons.apache.org >> >> > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: dev-unsubscr...@commons.apache.org > For additional commands, e-mail: dev-h...@commons.apache.org > --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@commons.apache.org For additional commands, e-mail: dev-h...@commons.apache.org
