sqlparser

We rely on SourceFile.codeUnits, added in 1.10.0.

• Re-release of version 0.44.6 which contained breaking changes and should not have been released as a patch version.
• Breaking: Refactor DartPlaceholder to a sealed class.

• Fix join analysis to properly treat the left side of a RIGHT or FULL
  join as nullable (#3812).
• Fix CaseInsensitiveMap.containsKey to be case-insensitive.

• Fix join analysis to properly treat the left side of a RIGHT or FULL join as nullable (#3812).
• Fix CaseInsensitiveMap.containsKey to be case-insensitive.

• Support ALTER TABLE ADD/DROP CONSTRAINT statements.

• Support ALTER TABLE ALTER COLUMN statements.

• Add support for features added in SQLite 3.52.0.
• Add supportPostgresCasts field on EngineOptions to parse :: casts.

• Better error recovery for select statements without result columns.

• Expose optional table name token for StarResultColumn.

• Refactor the different parse methods on SqlEngine into a single one taking an ParserEntrypoint enum.
• In drift files, allow reading imports and statement metadata from comments.
• Make Queryable and TableOrSubquery sealed classes, remove Queryable.when.
• Expose tokens making up References and TableReferences.
• Turn AS clauses into an explicit AST node with better spans.

• Make NamedWindowDeclaration an AST node.
• Support parsing DROP, VACUUM, REINDEX, ATTACH, DETACH, SAVEPOINT RELEASE, ROLLBACK, ANALYZE, PRAGMA and ALTER TABLE statements.
• Add SchemaBuffer class to apply ALTER TABLE and DROP statements to CREATE statements.

• Allow parsing SQL from FileSpans, which is convenient for SQL embedded as text in outer structures.

• Support new features introduced in SQLite version 3.51.0.

• Fix unresolved references in CTEs resolving against the scope of the main query.
• Static analysis support for the PowerSync SQLite extension.

• Improve error message on unknown columns when it looks like the identifier should have been a string literal.
• Infer the output of lag, lead and nth_value to be nullable.

• Support new features introduced in SQLite version 3.50.0.

• Replace ColonNamedVariable with NamedVariable for all named variables.
• Analysis support for SQLite 3.48.
• Fix nullability analysis around fts5 tables (enabled when raising the version to 3.48 to preserve backwards-compatibility).

• Add support for the dbstat module.
• Prioritize null propagation in type resolver, leading to more accurate analysis on which columns are nullable.

• Fix false-positive lint for a parameter count mismatch on bm25().
• Fix type interference around fts5 function calls.

• Improve recovery in parser when encountering syntax errors.

• When using the parse methods on SqlEngine, tokenizer errors are now included in the result instead of throwing an exception.

• Fix upcoming unreachable_switch_default lint.

• Resolve json_extract return types from context if possible.
• Warn when INSTEAD OF triggers are not used on views.
• Represent writes to views in TableWrite.

• Refine nullability analysis for subquery expressions: Queries with aggregate invocations are no longer considered nullable (the aggregate invocation had to be a top-level expression before).

• Add support for sqlite 3.46.0.
• Make columns coming from subquery expressions nullable.

• Add support for the geopoly module.

• Fix IN expressions accepting aliases, causing some queries to get parsed incorrectly.

• Fix parsing binary literals.
• Expand support for IN expressions, they now support tuples on the left-hand side and the shorthand syntax for table references and table-valued functions.
• Drift extensions: Allow custom class names for CREATE VIEW statements.
• Drift extensions: Support the INT64 hint for CREATE TABLE statements.

• Allow selecting from virtual tables using the table-valued function syntax.

• Fix explicit NULL column constraints being dropped when converting nodes to SQL.
• Add analysis errors for illegal unqualified references to old and new in triggers.
• Analysis support for sqlite 3.45 and jsonb functions.

• Support the column-name-list syntax for updates, thanks to @tibotix.

• Treat the result of sum() as nullable when inferring types.
• Support features added in sqlite 3.44:
  • ORDER BY clauses as part of aggregate functions.
  • Support concat, concat_ws and string_agg.

• Turn ResolvedType.hints into a list, supporting multiple type hints.

• Fix star columns expanding to more columns than they should.

• Add CaseInsensitiveMap.of to wrap existing maps.

• Add the sqlite3_schema table to the builtin tables supported by every SqlEngine instance.
• Support the timediff and octet_length functions from sqlite 3.43.0.

• Add SqlEngine.parseMultiple to parse multiple statements into one AST.

• Fix WITH clauses not being resolved for compound select statements.

• Fix false-positive "unknown table" errors when the same table is used in a join with and then without an alias.

• Report syntax error for WITH clauses in triggers.

• Add previous and next fields for tokens

• Parser support for constructor names in WITH drift syntax.
• Support resolving IIF functions.
• Fix a crash when a CTE is used on an insert, update or delete statement.
• Fix wrong column names being reported for references in subqueries and CTEs.

• Fix false-positive warnings about AS aliases in subqueries used in triggers.

• Support the unhex function added in sqlite 3.41.0
• Support custom keyword sets when formatting SQL.

• Add mappedBy to ExpressionResultColumn when parsing in drift mode.

• Fix missing space when formatting aggregate functions.

• Remove token parameter from constructor in Literal subclasses and NumberedVariable.

• Better analysis support for ANY columns in STRICT tables.
• Assign resolved schema columns to synctactical ResultColumn in queries.

• Make Fts5Table constructor public.

• Analysis support for the spellfix extension.

• Support resolving the fts5vocab module when fts5 is enabled - thanks to @FaFre.
• Support the rtree extension - also thanks to @FaFre!
• Improve references resolving across subqueries.

• Gracefully handle tokenizer errors related to @ or $ variables.

• Apply type hints for date times on textual datetime functions as well.

• Refactor how tables and columns are resolved internally.
• Lint for DISTINCT misuse in aggregate function calls.
• Support the RIGHT and FULL join operators added in sqlite 3.39.0.
• Support IS DISTINCT FROM and IS NOT DISTINCT FROM syntax added in sqlite 3.39.0.
• Fix type inference for SUM() calls around int "subtypes" (like booleans).

• Analysis support for new features in sqlite version 3.38.
• Replace internal moor references with drift references.

• Fix SQL generation for upsert statements with a conflict target.

• Support LIST columns for a drift-specific feature.

• Improve handling of drift-specific column types in STRICT tables.

• Make the result of group_concat nullable.

• Support generated columns.
• Support features introduced in sqlite version 3.37, most notably STRICT tables.

• Fix the AST comparator missing errors for different amount of children.

• Fix unecessary errors around fts5 tables
• Merge all moor-specific nodes into a single visitMoorSpecific visitor method
• Parse BEGIN and COMMIT statements
• Improve type inference around RETURNING clauses.