Calcite - Dialect (SqlDialect)

About

A dialect in calcite represents a language of a database.

It determines how the SQL tree (SqlNodes) are transformed SQL (e.g. generate “LIMIT 5” or “FETCH 5 ROWS”)

They are all in the dialect package

Example: Print a sql tree with a dialect

System.out.println(sqlNode.toSqlString(OracleSqlDialect.DEFAULT));

Powered by ComboStrap