有没有办法解析SQL查询以提取列名和表名？

import sqlparse

sql_query = "SELECT column1, column2 FROM table1 WHERE column1 > 100"
parsed = sqlparse.parse(sql_query)[0]

# 提取列名
columns = [token.value for token in parsed.tokens if isinstance(token, sqlparse.sql.Identifier)]

# 提取表名
from_keyword = sqlparse.sql.Token(sqlparse.tokens.Keyword, 'FROM')
from_pos = parsed.token_index(from_keyword)
if from_pos:
    table_name = parsed.tokens[from_pos + 1].value

print("Columns:", columns)
print("Table name:", table_name)

Columns: ['column1', 'column2']
Table name: table1