Querydsl as a SQL Builder ?

220 views
Skip to first unread message

Timo Westkämper

unread,
Mar 15, 2013, 5:00:48 PM3/15/13
to quer...@googlegroups.com
Hi.

Is someone interested in using Querydsl as an SQL Builder?

The use case might be something like this

- create the Querydsl SQL query
- populate it
- extract the SQL query and bindings
- do something else

jOOQ supports direct extraction of the SQL as shown here http://www.jooq.org/doc/3.0/manual/getting-started/use-cases/jooq-as-a-sql-builder-with-code-generation/

In Querydsl it is not as straight forward, and the lower level SQLSerializer class has to be used for that.

Br,
Timo

--
Timo Westkämper
Mysema Oy
+358 (0)40 591 2172
www.mysema.com


Vivien Henriet

unread,
Mar 16, 2013, 9:49:55 AM3/16/13
to quer...@googlegroups.com
Hello,

I was looking for that few days ago.
Since I can't find it in QueryDSL, I've subclassed SQLQuery classes to be able to extract the SQL string and bindings.
I find my solution quite ugly, because I had to "duplicate" some code from the library and put it in my project.

So yes, It will be very useful for my if queryDSL can provide this functionality directly.

Vivien

Dingo

unread,
Mar 16, 2013, 10:36:14 AM3/16/13
to quer...@googlegroups.com
I'd like to see SQL get some loving like this builder support and advanced concepts like windowing thru' ordered analytics.

Timo Westkämper

unread,
Mar 16, 2013, 1:29:38 PM3/16/13
to Querydsl on behalf of Vivien Henriet
Hi.


Here is a ticket for it

https://github.com/mysema/querydsl/issues/363

Please comment under the ticket for related comments.

Timo
 

Vivien

--
You received this message because you are subscribed to the Google Groups "Querydsl" group.
To unsubscribe from this group and stop receiving emails from it, send an email to querydsl+u...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

Timo Westkämper

unread,
Mar 16, 2013, 1:31:11 PM3/16/13
to Querydsl on behalf of Dingo
Hi.

On Sat, Mar 16, 2013 at 4:36 PM, Dingo via Querydsl <querydsl+noreply-APn2wQe4FD2Q6KB...@googlegroups.com> wrote:
I'd like to see SQL get some loving like this builder support and advanced concepts like windowing thru' ordered analytics.

Could you please create a ticket for this and describe the missing functionality in more detail? Thanks.

Timo
 

--
You received this message because you are subscribed to the Google Groups "Querydsl" group.
To unsubscribe from this group and stop receiving emails from it, send an email to querydsl+u...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


Reply all
Reply to author
Forward
0 new messages