Hello fellow JOOQers
I have a need to mix raw SQL strings with SQL generated by the DSL.
I have a CTE which is far too cumbersome to express in jooq - for the sake
of simplicity however lets say my cte is
SELECT foo FROM bar
I would like to do something like this
String myCte = "SELECT foo FROM bar";
DSL.with("mycte").as(myCte)
.select( ... )
.from(... )
.where( ... )
.fetch().steam().
//etc..
So basically what I want to do is mix SQL strings and the DSL. Doesn't seem
like this is possible because with("mycte").as() takes Select<?> as a param
and not a String.
Is what I want to do possible or just too crazy?
Thanks,
Max
--
You received this message because you are subscribed to the Google Groups "jOOQ
User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to jooq-user+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
