subquery mistake alias as table name in visualiztion

[shengkui]

Describe the bug

Alias of a subquery show as a Table node in Visualizes Table/Column Lineage

SQL

CREATE TABLE main.tab1 AS (
  SELECT * FROM (
    SELECT T0.* FROM (SELECT * FROM main.tab0) T0 WHERE T0.num < 100
  )
)

To Reproduce
Note here we refer to SQL provided in prior step as stored in a file named test.sql

sqllineage -f test.sql --dialect=ansi -g

Web UI (Web User Interface):

Expected behavior

There should be no table node for alias of subquery.

Python version (available via python --version)

• 3.10.13

SQLLineage version (available via sqllineage --version):

• 1.4.9

[reata]

Bug confirmed. Thanks for reporting.

The column lineage is also incorrect in this case.

[reata]

This is a regression issue introduced in v1.4.9 via fbad73a, v1.4.8 was OK.

The commit is to make subquery alias case insensitive. So that we can resolve SELECT t0.* FROM (SELECT * FROM main.tab0) T0 correctly.

But that was only half done. Qualifier name was not converted to lower case correctly.