sqlparser 0.6.0

Parses sqlite statements and performs static analysis on them

0.6.0

• 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

0.5.0

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

0.4.0

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

0.3.0

• 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

0.2.0

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

0.1.2

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

0.1.1

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

0.1.0

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