tree-sitter-sql

tree-sitter-sql copied to clipboard

To avoid potential name collision, this PR renamed the alias name `default` to `default_value`

pplam

Supported the DO statement for PostgreSQL. Ref: https://www.postgresql.org/docs/current/sql-do.html

pplam

Supported the VACUUM statement and improved the alias rule. Ref: https://www.postgresql.org/docs/current/sql-vacuum.html

pplam

Supported combining queries, JSON comparison operators and type cast as column default. Ref: * https://www.postgresql.org/docs/current/queries-union.html * https://www.postgresql.org/docs/current/functions-json.html

pplam

Supported composite values of the form: ~~~ (expression1, expression2, ...) ~~~ as an expression, and resolved the syntax conflicts. The conflict is explained at https://www.postgresql.org/docs/current/queries-table-expressions.html#QUERIES-GROUPING-SETS as following >Note The construct...

pplam

Support more comparison predicates: 1. BETWEEN...AND expression; 2. ISNULL and NOTNULL; 3. IS UNKNOWN and IS NOT UNKNOWN; Ref: https://www.postgresql.org/docs/current/functions-comparison.html

pplam

Some more improvements: - Fully support TRUNCATE statement; - Supported DISTINCT clause in SELECT statement; - Improved the IN expression to support select-subexpression;

pplam

Improved the INSERT statement according to doc https://www.postgresql.org/docs/14/sql-insert.html

pplam

1. Improved the CREATE INDEX statement according to https://www.postgresql.org/docs/current/sql-createindex.html; 2. Added `expression_list`, `identifier_list`, `assignment_expression_list`, `column_list` and `option_list` of form `seq("(", commaSep1(*), ")")` and use them everywhere to increase the reusability...

pplam

Improved the UPDATE statement according to doc https://www.postgresql.org/docs/current/sql-update.html

pplam