sqlparser

• New analysis checks for RETURNING: Disallow table.* syntax and aggregate expressions
• Support RAISE expressions in triggers
• Fix resolving columns when RETURNING is used in an UPDATE FROM statement
• Fix aliases to rowid being reported as nullable

• Breaking: Change InsertStatement.upsert to a list of upsert clauses
  • Support multiple upsert clauses
  • Do not require a conflict target in the last clause
• Support RETURNING clauses in updates, deletes and inserts
• Support FROM clauses in UPDATE statements
• Support MATERIALIZED/NOT MATERIALIZED hints in common table expressions
• Add BuiltInMathExtension which corresponds to the -DSQLITE_ENABLE_MATH_FUNCTIONS compile-time option for sqlite.
• Add EngineOptions.version argument to specify the desired sqlite version. Using newer features will be reported as analysis warnings.
• Fix rank columns of fts5 tables being misreported as integers

• Fix views using common table expressions

• Migrate to null-safety
• Remove legacy type inference
• Parser support for new moor features

• New package:sqlparser/utils/node_to_text.dart library that turns an AST node back into a textual representation.
• Fix precedence of CASE expressions

• Scan identifiers with [bracket syntax]
• NumericToken now contains individual lexemes making up the number
• Improve error messages in some scenarios
• Fix type inference for binary expressions where the operands have incompatible types
• Improve type inference around NULL

• Breaking: Made RecursiveVisitor.visit, visitList and visitExcept an extension on AstVisitor.
• Support the transformer pattern to modify ast nodes
• Breaking: FrameBoundary, DeleteTarget, UpdateTarget, DefaultValues and InsertTarget are no longer constant
• Breaking: Removed visitQueryable. Use defaultQueryable instead.
• Support parsing and analyzing CREATE VIEW statements (see SchemaFromCreateTable.readView). Thanks to @mqus for their contribution!
• SqlEngine.parse will no longer throw when there's a parsing error (use ParseResult.errors instead).
• Parse DEFERRABLE clauses on foreign key constraints
• Parse NULLS FIRST and NULLS LAST on ORDER BY terms

• New package:sqlparser/utils/find_referenced_tables.dart library. Use it to easily find all referenced tables in a query.
• Support row values including warnings about misuse

• Support collate expressions in the new type inference ([#533](htt ps://github.com/simolus3/moor/issues/533))
• Added visitCollateExpression to the visitor classes

• Remove SqlEngine.withOptions constructor - the default constructor now takes options
• Changed SelectStatement.from from List<Queryable> to Queryable?. Selecting from multiple tables with a comma will now be parsed as a JoinClause.
• Changed SelectStatementAsSource.statement from SelectStatement to BaseSelectStatement and allow compound select statements to appear in a FROM clause
• Support the VALUES clause as select statement
• The new type inference engine is now enabled by default and the enableExperimentalTypeInference option has been removed. To continue using the old engine, the useLegacyTypeInference flag can be used.

• New feature: Table valued functions.
• Breaking: Removed the enableJson1 parameter on EngineOptions. Add a Json1Extension instance to enabledExtensions instead.
• Parse rowid as a valid reference when needed (SELECT rowid FROM tbl is now parsed correctly)
• Parse CURRENT_TIME, CURRENT_DATE and CURRENT_TIMESTAMP
• Parse UPSERT clauses for insert statements

• Breaking: Added an argument type and argument to the visitor classes
• Experimental new type inference algorithm (SqlEngine.withOptions(EngineOptions(enableExperimentalTypeInference: true)))
• Support CAST expressions and the ISNULL / NOTNULL postfixes
• Support parsing CREATE TRIGGER statements
• Support parsing CREATE INDEX statements

• Optionally support the json1 module
• Optionally support the fts5 module

• Support common table expressions
• Handle special rowid, oid, __rowid__ references
• Support references to sqlite_master and sqlite_sequence tables

• parse compound select statements
• scan comment tokens
• experimental auto-complete engine (only supports a tiny subset based on the grammar only)
• some features that are specific to moor

0.3.0+1: Accept \r characters as whitespace

• Parse CREATE TABLE statements
• Extract schema information from parsed create table statements with SchemaFromCreateTable.

• parse COLLATE expressions
• fix wrong order in parsed LIMIT clauses

Attempt to recognize when a bound variable should be an array (eg. in WHERE x IN ?). Also fixes a number of parsing bugs:

• Parses tuples, proper type resolution for IN expressions
• Don't resolve references to tables that don't appear in the surrounding statement.
• Parse joins without any additional operator, e.g. table1 JOIN table2 instead of table1 CROSS JOIN table2.
• Parser now complains when parsing a query doesn't fully consume the input

Initial version, can parse most statements but not DELETE, common table expressions and other advanced features.