Not fully processed top-level subquery in DML

[maoxingda]

SQL

INSERT INTO tab1 (col1, col2) ((SELECT * FROM tab2 UNION SELECT * FROM tab3))
INSERT INTO tab1 (col1, col2) (((SELECT * FROM tab2 UNION SELECT * FROM tab3)))

CREATE VIEW my_view (random1,random2) AS ((SELECT col1,col2 FROM tbl))
CREATE VIEW my_view (random1,random2) AS (((SELECT col1,col2 FROM tbl)))

To Reproduce

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

from sqllineage.runner import LineageRunner

with open("test.sql") as f:
    sql = f.read()

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

lr.print_table_lineage()

Actual behavior

Statements(#): 1
Source Tables:
    
Target Tables:
    <default>.tab1

Expected behavior

Statements(#): 1
Source Tables:
    <default>.tab2
    <default>.tab3
Target Tables:
    <default>.tab1

Python version (available via python --version)

• 3.10

SQLLineage version (available via sqllineage --version):

• 1.5.0

Additional context