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));