Available in versions: Dev (3.20) | Latest (3.19) | 3.18 | 3.17 | 3.16 | 3.15 | 3.14 | 3.13 | 3.12 | 3.11 | 3.10

SQL translator

Applies to ✅ Open Source Edition   ✅ Express Edition   ✅ Professional Edition   ✅ Enterprise Edition

The SQL parser can be used as a SQL translator, as shown in action on our website: https://www.jooq.org/translate, or via the SQL parser CLI. The fact that translation happens is just an emerging feature of combining:

  • The parser API to parse a SQL string into the jOOQ query object model API
  • Using jOOQ to render the query object model again into a SQL string.

The simplest example is this one:

System.out.println(create.parser().parse("SELECT 1").toString());

This will parse the generic SQL string SELECT 1, and render it according to the configured Configuration, SQLDialect, Settings, etc.

Feedback

Do you have any feedback about this page? We'd love to hear it!

The jOOQ Logo