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

This documentation is for the unreleased development version of jOOQ. Click on the above version links to get this documentation for a supported version of jOOQ.

SQL Parser CLI

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

The Parser API can be used as a translator between source and target dialects programmatically, as we've seen in the previous section about the parser API. This functionality can also usefully be accessed on the command line as shown below:

$ java -cp jooq-3.20.0-SNAPSHOT.jar:reactive-streams-1.0.3.jar:r2dbc-spi-1.0.0.RELEASE.jar org.jooq.ParserCLI -h
  -f / --formatted                                                    Format output SQL
  -h / --help                                                         Display this help
  -k / --keyword                                  <RenderKeywordCase> Specify the output keyword case (org.jooq.conf.RenderKeywordCase)
  -i / --identifier                               <RenderNameCase>    Specify the output identifier case (org.jooq.conf.RenderNameCase)
  -Q / --quoted                                   <RenderQuotedNames> Specify the output identifier quoting (org.jooq.conf.RenderQuotedNames)
  -F / --from-dialect                             <SQLDialect>        Specify the input dialect (org.jooq.SQLDialect)
  -T / --to-dialect                               <SQLDialect>        Specify the output dialect (org.jooq.SQLDialect)
  -s / --sql                                      <String>            Specify the input SQL string
  -S / --schema                                   <String>            Specify the input schema

Commercial distribution only features:
  --render-coalesce-to-empty-string-in-concat     <boolean>
  --render-optional-inner-keyword                 <RenderOptionalKeyword>
  --render-optional-outer-keyword                 <RenderOptionalKeyword>
  --render-optional-as-keyword-for-field-aliases  <RenderOptionalKeyword>
  --render-optional-as-keyword-for-table-aliases  <RenderOptionalKeyword>
  --transform-ansi-join-to-table-lists            <boolean>
  --transform-qualify                             <Transformation>
  --transform-rownum                              <Transformation>
  --transform-group-by-column-index               <Transformation>
  --transform-inline-cte                          <Transformation>
  --transform-table-lists-to-ansi-join            <boolean>
  --transform-unneeded-arithmetic                 <TransformUnneededArithmeticExpressions>

  -I / --interactive                                                  Start interactive mode"

$ java -cp jooq-3.20.0-SNAPSHOT.jar:reactive-streams-1.0.3.jar:r2dbc-spi-1.0.0.RELEASE.jar org.jooq.ParserCLI -T ORACLE -s "SELECT substring('abcde', 2, 3)"
select substr('abcde', 2, 3) from dual;

Windows users: Please replace : by ; in the above examples.

Another way to use this API is the https://www.jooq.org/translate website.

References to this page


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

The jOOQ Logo