pip install sqlparse
python
import sqlparse
python
sql = "SELECT * FROM employees WHERE salary > 50000"
parsed = sqlparse.parse(sql)[0]
python
sql = "SELECT * FROM employees WHERE salary > 50000"
formatted = sqlparse.format(sql, reindent=True, keyword_case='upper')
print(formatted)
# SELECT *
# FROM employees
# WHERE salary > 50000
python
sql = "SELECT * FROM employees; SELECT * FROM departments;"
queries = sqlparse.split(sql)
for query in queries:
parsed = sqlparse.parse(query)[0]
print(parsed)
# SELECT * FROM employees;
# SELECT * FROM departments;
