JOOQ Tooling

2024-01-24 Thread Kevin Jones
Hey Lukas, is there a way to take a JOOQ expression (and a dialect) and see what the generated SQL looks like without actually running the 'real' code? i.e. some tool or API I can use to decode the DSL into SQL, Thanks Kevin -- You received this message because you are subscribed to the Goog

Re: JOOQ Tooling

2024-01-24 Thread Simon Martinelli
Hi Kevin, Simon here :-) You can call getSQL on the query. Check out the documentation: https://www.jooq.org/doc/latest/manual/getting-started/use-cases/jooq-as-a-sql-builder-without-codegeneration/ Simon > On 24 Jan 2024, at 10:36, Kevin Jones wrote: > > Hey Lukas, > > is there a way to

Re: JOOQ Tooling

2024-01-24 Thread Lukas Eder
Hi Kevin, Keep in mind that *every* jOOQ query is a dynamic SQL query, even if jOOQ's API tries hard not to make it look this way by mimicking actual SQL syntax. By dynamic, I mean: - jOOQ (or an IDE) doesn't really know if any QueryParts are composed dynamically, e.g. like (something ? A.eq(1)