Not Using Column Name Specified in Query For CTE within Query

[maoxingda]

Describe the bug

• When the column names in the target table are different from those in the source table, the column lineage is incorrect.

SQL
Paste the SQL text here. For example:

insert into
    public.tgt_tbl1
(
    id
)
with
    cte1 as (
        select name from public.src_tbl1
    )
select
    name
from
    cte1
;

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

with open(sql_file, 'r') as f:
    sql = f.read()

lr = LineageRunner(sql, dialect='redshift')

lr.print_column_lineage()

public.tgt_tbl1.name <- cte1.name <- public.src_tbl1.name

Expected behavior

public.tgt_tbl1.id <- cte1.name <- public.src_tbl1.name

Python version (available via python --version)

• 3.11.5

SQLLineage version (available via sqllineage --version):

• 1.4.8

[reata]

Bug confirmed. Thanks for reporting.