从sq查找表

Question

有没有一种方法可以通过查看sql来查找表。可能正在使用python或其他工具

例如

 SELECT *
          FROM TABLEA TFR
          JOIN TABLEB TR
            ON (TFR.DIMENSIONID = TR.DIMENSIONID)
         WHERE TFR.DAYCD >= TO_CHAR(TO_DATE('02/18/2019', 'MM/dd/yyyy'), 'YYYYMMDD')
           AND TFR.DAYCD <= TO_CHAR(TO_DATE('02/20/2019', 'MM/dd/yyyy'), 'YYYYMMDD')
           AND TFR.DURATIONTYPEID IN ('1')
         GROUP BY TFR.DAYCD, TR.DIMENSION, TR.ORDERID

我们想从中提取TABLEA , TABLEB。我试过https://sqlparse.readthedocs.io/en/latest/，但不起作用

函数位于https://github.com/andialbrecht/sqlparse/blob/master/examples/extract_table_names.py 以下是代码

sql='''

SELECT *
          FROM TABLEA TFR
          JOIN TABLEB TR
            ON (TFR.DIMENSIONID = TR.DIMENSIONID)
         WHERE TFR.DAYCD >= TO_CHAR(TO_DATE('02/18/2019', 'MM/dd/yyyy'), 'YYYYMMDD')
           AND TFR.DAYCD <= TO_CHAR(TO_DATE('02/20/2019', 'MM/dd/yyyy'), 'YYYYMMDD')
           AND TFR.DURATIONTYPEID IN ('1')
         GROUP BY TFR.DAYCD, TR.DIMENSION, TR.ORDERID


'''
extract_tables(sql)