Source table name not parsed in query

[soheilmoattar]

Describe the bug
The result does not return the source table.

SQL

DROP TABLE IF EXISTS table_b;

create table table_b as

SELECT explode(sequence(to_date((select min(balance_date) FROM table_a)),
to_date((select max(balance_date) from table_a)), interval 1 day)) as date;

To Reproduce

For example:

from sqllineage.runner import LineageRunner
with open("test.sql") as f:
    sql = f.read()
result = LineageRunner(sql, dialect="sparksql")
print(result)

**Result
table_a should be returned as source table, but nothing is returned. Also tried with ansi dialect but i got the same result.

Source Tables:

Target Tables:
    <default>.table_b

Expected behavior

Source Tables:
     <default>.table_a
Target Tables:
    <default>.table_b

Python version (available via python --version)

• 3.10.14

SQLLineage version (available via sqllineage --version):

• 1.5.3