codecov-io: # [Codecov](https://codecov.io/gh/reata/sqllineage/pull/17?src=pr&el=h1) Report
> Merging [#17](https://codecov.io/gh/reata/sqllineage/pull/17?src=pr&el=desc) into [master](https://codecov.io/gh/reata/sqllineage/commit/b613ec49de0b613cfaa74b37282f410659dcbc06?src=pr&el=desc) will **decrease** coverage by `0.59%`.
> The diff coverage is `100%`.

[![Impacted file tree graph](https://codecov.io/gh/reata/sqllineage/pull/17/graphs/tree.svg?width=650&token=latkaw2Lx6&height=150&src=pr)](https://codecov.io/gh/reata/sqllineage/pull/17?src=pr&el=tree)

```diff
@@            Coverage Diff            @@
##           master      #17     +/-   ##
=========================================
- Coverage   79.38%   78.78%   -0.6%     
=========================================
  Files           1        1             
  Lines          97       99      +2     
=========================================
+ Hits           77       78      +1     
- Misses         20       21      +1
```


| [Impacted Files](https://codecov.io/gh/reata/sqllineage/pull/17?src=pr&el=tree) | Coverage Δ | |
|---|---|---|
| [sqllineage/core.py](https://codecov.io/gh/reata/sqllineage/pull/17/diff?src=pr&el=tree#diff-c3FsbGluZWFnZS9jb3JlLnB5) | `78.78% <100%> (-0.6%)` | :arrow_down: |

------

[Continue to review full report at Codecov](https://codecov.io/gh/reata/sqllineage/pull/17?src=pr&el=continue).
> **Legend** - [Click here to learn more](https://docs.codecov.io/docs/codecov-delta)
> `Δ = absolute <relative> (impact)`, `ø = not affected`, `? = missing data`
> Powered by [Codecov](https://codecov.io/gh/reata/sqllineage/pull/17?src=pr&el=footer). Last update [b613ec4...325dece](https://codecov.io/gh/reata/sqllineage/pull/17?src=pr&el=lastupdated). Read the [comment docs](https://docs.codecov.io/docs/pull-request-comments).

diff --git a/sqllineage/core.py b/sqllineage/core.py
index 301c818..2f5e0b6 100644
--- a/sqllineage/core.py
+++ b/sqllineage/core.py
@@ -3,7 +3,7 @@ import sys
 from typing import List, Set
 
 import sqlparse
-from sqlparse.sql import Function, Identifier, IdentifierList, Statement, TokenList
+from sqlparse.sql import Function, Identifier, Parenthesis, Statement, TokenList
 from sqlparse.tokens import Keyword, Token, Whitespace
 
 SOURCE_TABLE_TOKENS = ('FROM', 'JOIN', 'INNER JOIN', 'LEFT JOIN', 'RIGHT JOIN', 'LEFT OUTER JOIN', 'RIGHT OUTER JOIN',
@@ -51,11 +51,9 @@ Target Tables:
         return self._target_tables
 
     def _extract_from_token(self, token: Token):
-        if not isinstance(token, TokenList):
-            return
         source_table_token_flag = target_table_token_flag = temp_table_token_flag = False
         for sub_token in token.tokens:
-            if isinstance(token, TokenList) and not isinstance(sub_token, (Identifier, IdentifierList)):
+            if isinstance(sub_token, TokenList):
                 self._extract_from_token(sub_token)
             if sub_token.ttype in Keyword:
                 if sub_token.normalized in SOURCE_TABLE_TOKENS:
@@ -75,7 +73,13 @@ Target Tables:
                     continue
                 else:
                     assert isinstance(sub_token, Identifier)
-                    self._source_tables.add(sub_token.get_real_name())
+                    if isinstance(sub_token.token_first(), Parenthesis):
+                        # SELECT col1 FROM (SELECT col2 FROM tab1) dt, the subquery will be parsed as Identifier
+                        # and this Identifier's get_real_name method would return alias name dt
+                        # referring https://github.com/andialbrecht/sqlparse/issues/218 for further information
+                        pass
+                    else:
+                        self._source_tables.add(sub_token.get_real_name())
                     source_table_token_flag = False
             elif target_table_token_flag:
                 if sub_token.ttype == Whitespace:

subquery mistake alias as table name
```
$ python -m sqllineage.core -e "SELECT col1 FROM (SELECT col2 from tab1) dt"
Statements(#): 1
Source Tables:
    dt
Target Tables:

```

expect source table as tab1
diff --git a/tests/test_select.py b/tests/test_select.py
index cea96ef..49fe323 100644
--- a/tests/test_select.py
+++ b/tests/test_select.py
@@ -40,6 +40,10 @@ def test_select_count():
     helper("SELECT COUNT(*) FROM tab1", {"tab1"})
 
 
+def test_select_subquery():
+    helper("SELECT col1 FROM (SELECT col2 FROM tab1) dt", {"tab1"})
+
+
 def test_select_inner_join():
     helper("SELECT * FROM tab1 INNER JOIN tab2", {"tab1", "tab2"})
 

pip install -e .
parse_log_pytest
pytest
pytest
3.6
pytest --no-header -rA --tb=line --color=no -p no:cacheprovider -W ignore::DeprecationWarning
attrs @ file:///opt/conda/conda-bld/attrs_1642510447205/work
certifi==2021.5.30
importlib-metadata @ file:///tmp/build/80754af9/importlib-metadata_1631916693255/work
iniconfig @ file:///home/linux1/recipes/ci/iniconfig_1610983019677/work
more-itertools @ file:///tmp/build/80754af9/more-itertools_1637733554872/work
packaging @ file:///tmp/build/80754af9/packaging_1637314298585/work
pluggy @ file:///tmp/build/80754af9/pluggy_1615976315926/work
py @ file:///opt/conda/conda-bld/py_1644396412707/work
pyparsing @ file:///tmp/build/80754af9/pyparsing_1635766073266/work
pytest==6.2.4
-e git+https://github.com/reata/sqllineage.git@b613ec49de0b613cfaa74b37282f410659dcbc06#egg=sqllineage
sqlparse==0.3.1
toml @ file:///tmp/build/80754af9/toml_1616166611790/work
typing_extensions @ file:///opt/conda/conda-bld/typing_extensions_1647553014482/work
zipp @ file:///tmp/build/80754af9/zipp_1633618647012/work

name: sqllineage
channels:
  - defaults
  - https://repo.anaconda.com/pkgs/main
  - https://repo.anaconda.com/pkgs/r
  - conda-forge
dependencies:
  - _libgcc_mutex=0.1=main
  - _openmp_mutex=5.1=1_gnu
  - attrs=21.4.0=pyhd3eb1b0_0
  - ca-certificates=2025.2.25=h06a4308_0
  - certifi=2021.5.30=py36h06a4308_0
  - importlib-metadata=4.8.1=py36h06a4308_0
  - importlib_metadata=4.8.1=hd3eb1b0_0
  - iniconfig=1.1.1=pyhd3eb1b0_0
  - ld_impl_linux-64=2.40=h12ee557_0
  - libffi=3.3=he6710b0_2
  - libgcc-ng=11.2.0=h1234567_1
  - libgomp=11.2.0=h1234567_1
  - libstdcxx-ng=11.2.0=h1234567_1
  - more-itertools=8.12.0=pyhd3eb1b0_0
  - ncurses=6.4=h6a678d5_0
  - openssl=1.1.1w=h7f8727e_0
  - packaging=21.3=pyhd3eb1b0_0
  - pip=21.2.2=py36h06a4308_0
  - pluggy=0.13.1=py36h06a4308_0
  - py=1.11.0=pyhd3eb1b0_0
  - pyparsing=3.0.4=pyhd3eb1b0_0
  - pytest=6.2.4=py36h06a4308_2
  - python=3.6.13=h12debd9_1
  - readline=8.2=h5eee18b_0
  - setuptools=58.0.4=py36h06a4308_0
  - sqlite=3.45.3=h5eee18b_0
  - tk=8.6.14=h39e8969_0
  - toml=0.10.2=pyhd3eb1b0_0
  - typing_extensions=4.1.1=pyh06a4308_0
  - wheel=0.37.1=pyhd3eb1b0_0
  - xz=5.6.4=h5eee18b_1
  - zipp=3.6.0=pyhd3eb1b0_0
  - zlib=1.2.13=h5eee18b_1
  - pip:
      - sqlparse==0.3.1
prefix: /opt/conda/envs/sqllineage

tests/test_select.py::test_select_subquery
tests/test_select.py::test_select tests/test_select.py::test_select_asterisk tests/test_select.py::test_select_value tests/test_select.py::test_select_function tests/test_select.py::test_select_with_where tests/test_select.py::test_select_with_comment tests/test_select.py::test_select_keyword_as_column_alias tests/test_select.py::test_select_with_table_alias tests/test_select.py::test_select_count tests/test_select.py::test_select_inner_join tests/test_select.py::test_select_join tests/test_select.py::test_select_left_join tests/test_select.py::test_select_left_semi_join tests/test_select.py::test_select_left_semi_join_with_on tests/test_select.py::test_select_right_join tests/test_select.py::test_select_full_outer_join tests/test_select.py::test_select_full_outer_join_with_full_as_alias tests/test_select.py::test_select_cross_join tests/test_select.py::test_select_cross_join_with_on tests/test_select.py::test_select_join_with_subquery tests/test_select.py::test_with_select
sqllineage/core.py
sqllineage/core.py