SQLDialect.DEFAULT corresponds to the "default dialect", or also the "jOOQ dialect", which does not really exist on any existing SQL database in exactly this form. Historically, it often generated a ...
When upgrading from 0.9.6 to 1.0.0 it seems like the default SQL style has been set to Standard SQL and not to legacy SQL which it was before. I can't find any documentation for this breaking change.