pip install sqlparse
import sqlparse
python
import sqlparse
def analyze_sql(sql):
parsed = sqlparse.parse(sql)
for statement in parsed:
formatted = statement.format()
tables = statement.get_real_name()
columns = statement.get_columns()
where = statement.where
new_statement = sqlparse.parse("SELECT new_column FROM new_table WHERE condition")[0]
statement.tokens = new_statement.tokens
print("")
sql = "SELECT column1, column2 FROM table1 WHERE column1 = 'value'"
analyze_sql(sql)
