Const
Databricks grammar facts. LIMIT and OFFSET, no TOP or FETCH FIRST (https://docs.databricks.com/en/sql/language-manual/sql-ref-syntax-qry-query.html); WITH RECURSIVE (https://docs.databricks.com/en/sql/language-manual/sql-ref-syntax-qry-select-cte.html); MINUS as an alternative for EXCEPT (https://docs.databricks.com/en/sql/language-manual/sql-ref-syntax-qry-select-setops.html); LATERAL (https://docs.databricks.com/en/sql/language-manual/sql-ref-syntax-qry-select-table-reference.html). node-sql-parser reads it with its Hive grammar.
LIMIT
OFFSET
WITH RECURSIVE
Databricks grammar facts.
LIMITandOFFSET, no TOP or FETCH FIRST (https://docs.databricks.com/en/sql/language-manual/sql-ref-syntax-qry-query.html);WITH RECURSIVE(https://docs.databricks.com/en/sql/language-manual/sql-ref-syntax-qry-select-cte.html); MINUS as an alternative for EXCEPT (https://docs.databricks.com/en/sql/language-manual/sql-ref-syntax-qry-select-setops.html); LATERAL (https://docs.databricks.com/en/sql/language-manual/sql-ref-syntax-qry-select-table-reference.html). node-sql-parser reads it with its Hive grammar.