v2.7.0

Features

• Add initial support for table identification by @azmy60 in #76

This feature requires passing identifyTables: true to the identify options. It will only pick up tables in very simple cases (no CTEs) for SELECT and INSERT queries and is not ready for broad usage. If enabled, should ideally see the tables used under new tables key in the identify result. If disabled, or using an unsupported query type, then tables will be an empty array.

Full Changelog: v2.6.0...v2.7.0

v2.6.0

Features

• Identify create virtual table sqlite statements by @MasterOdin in #73

Bugfixes

• Fix parsing trailing non-alphanumerics in mssql parameters by @azmy60 in #72

Full Changelog: v2.5.0...v2.6.0

v2.5.0

Features

• Add SHOW statements for generic/mysql to parser (#68) (thanks @wmontgomery)

v2.4.4

• Fix identifying queries with lowercase block openers (#63)
• Fix parsing single END statement (#64)

v2.4.3

• Fix identifying transaction statements (#60)
• Fix parsing bigquery control structures (#61)

v2.4.2

• Fix identifying DECLARE statements for bigquery (#58)

v2.4.1

• Allow OR REPLACE syntax in generic dialect

v2.4.0

• Fix identifying psql parameters followed by comma (#56)
• Add support for CREATE/DROP/ALTER PROCEDURE statements (#57) (thanks @nicolasgarnil)
• Add support for bigquery dialect (#57) (thanks @nicolasgarnil)

v2.3.0

Features

• Support passing oracle for the dialect option
• Support anonymous blocks for new Oracle dialect

v2.2.4

Bugfixes

• Identify all invalid statements as unknown when not in strict mode