SQL Translation

Use the jOOQ Parser to translate any SQL statement(s) to a different dialect.*

This is work in progress. Your help in improving our parser is greatly appreciated. See below how to report bugs.

Input Dialect

Output Dialect
Identifier Case
Identifier Quoting
Bind variables
AS keyword in SELECT
AS keyword in FROM
INNER keyword in JOIN
OUTER keyword in JOIN
More formatting Options Coming soon!

*How does it work?

The input dialect is a mixture of all of jOOQ's currently supported SQL dialects. The grammar can be found here.

The output is what jOOQ would generate if you ran the input query using a given dialect. It may not actually work on the target database, if the relevant feature isn't supported by the target database and jOOQ doesn't currently emulate it.

If you've found an error, or would like to suggest an improvement, please report it here, along with your input query: https://github.com/jOOQ/jOOQ/issues/new.

Cool, can I embed this in my application!?

Yes! And you don't even need to use the jOOQ API. The parser can be exposed through the JDBC API.

For more details, read this blog post: https://blog.jooq.org/2018/01/12/top-5-hidden-jooq-features/

Tell us what you think:

The jOOQ Logo