DSLContext dsl;
Settings settings = new Settings()
.withRenderNameStyle(RenderNameStyle.AS_IS).withRenderFormatted(true);
dsl = DSL.using(SQLDialect.DEFAULT, settings);
String sql = dsl.select().from(DSL.values(DSL.row(43,1234,"value1"),DSL.row(43,1235,"value2"))).getSQL();
System.out.println(sql);
Output is generating as below.
select v.c1, v.c2, v.c3 from (values (?, ?, ?), (?, ?, ?) ) v(c1, c2, c3)
--
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+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Thanks for the reply. My target database is Snowflake. So which dialect I should use. Also I am using jooq as sql query generator.
Hi,
Thanks for the reply. My target database is Snowflake. So which dialect I should use. Also I am using jooq as sql query generator.