SQL Translation
Use the jOOQ Parser to translate any SQL statement(s) to a different dialect.*
-- Put your SQL statement here
|
-- Put your schema definition here (optional)
--
-- While this is not a strict requirement, you will
-- get much better results as jOOQ knows about constraints,
-- data types, column names, etc. Especially when
-- translating to jOOQ/Java code, in case of which the
-- resulting jOOQ code can table and column references
-- from the code generator.
|
| Input Dialect |
|
| Search path, comma separated |
|
| Parse unknown functions |
|
| Formats |
| Date Format |
|
| Timestamp Format |
|
| Comments |
| Retain comments between queries |
|
| Enable ignore comment syntax |
|
| Ignore comment start token |
|
| Ignore comment stop token |
|
| Output Dialect |
|
| Keywords |
|
| Identifier Case |
|
| Identifier Quoting |
|
| Bind variables |
|
| Transformation options |
| Patterns (experimental) |
|
| Join style |
|
| QUALIFY |
|
| ROWNUM |
|
| inline CTE |
|
| GROUP BY <column index> |
|
| Remove unnecessary arithmetic |
|
| Stylistic options |
| AS keyword in SELECT |
|
| AS keyword in FROM |
|
| INNER keyword in JOIN |
|
| OUTER keyword in JOIN |
|
| More formatting Options |
Coming soon! |