v1.4.3

Enhancement

• Support postgres style type casts "keyword::TIMESTAMP" (#364)

Bugfix

• Missing column lineage from SELECT DISTINCT using non-validating dialect (#356)
• Missing column lineage with Parenthesis around column arithmetic operation (#355)
• Not Handling CTE at the start of query in DML (#328)

v1.4.2

Bugfix

• sqlparse v0.4.4 breaks non-validating dialect (#361)

v1.3.8

Bugfix

• sqlparse v0.4.4 breaks non-validating dialect (#361)

v1.4.1

Bugfix

• frontend app unable to load dialect when launched for the first time

v1.4.0

Great thanks to @nahuelverdugo, @ulixius9 and @pmbrull from @open-metadata community for contributing on feature Dialect-awareness lineage. Leveraging sqlfluff underneath, we're now able to give more correct lineage result with user input on SQL dialect.

Feature

• Dialect-awareness lineage (#302)
• support MERGE statement (#166)

Enhancement

• Use curved lines in lineage graph visualization (#320)
• Click to lock highlighted nodes in visualization (#318)
• Deprecate support for Python 3.6 and Python 3.7, add support for Python 3.11 (#319)
• support t-sql assignment operator (#205)

Bugfix

• exception when insert into qualified table followed by parenthesized query (#249)
• missing columns when current_timestamp as reserved keyword used in select clause (#248)
• exception when non-reserved keywords used as column name (#183)
• exception when non-reserved keywords used as table name (#93)

v1.3.7

Enhancement

• migrate demo site off Heroku to GitHub Pages (#288)
• remove flask-related dependencies by implementing a wsgi app (#287)

Bugfix

• exception with VALUES clause (#292)
• exception with Presto unnest function (#272)
• exception with snowflake generator statement (#214)

v1.3.6

Enhancement

• support MySQL RENAME TABLE statement (#267)
• auto deploy to Heroku with GitHub Actions (#232)

Bugfix

• handling parenthesis around subquery between union (#270)
• unable to extract alias of columns using function with CTAS (#253)
• exception when using lateral view (#225)

v1.3.5

Enhancement

• support parsing column in cast/try_cast with function (#254)
• support parsing WITH for bucketing in Trino (#251)

Bugfix

• incorrect column lineage with nested cast (#240)
• column lineages from boolean expression (#236)
• using JOIN with ON/USING keyword fails to determine source tables when followed by a parenthesis (#233)
• failure to handle multiple lineage path for same column (#228)

v1.3.4

Enhancement

• update black to stable version (#222)

Bugfix

• table/column lineage mixed up for self dependent SQL (#219)
• problem with SELECT CAST(CASE WHEN ...END AS DECIMAL(M,N)) AS col_name (#215)
• failed to parse source table from subquery with more than one parenthesis (#213)

v1.3.3

Enhancement

• smarter column-to-table resolution using query context (#203)

Bugfix

• column lineage for union operation (#207)
• subquery in where clause not parsed for table lineage (#204)