shell
pip install sqlparse
python
import sqlparse
python
import sqlparse
sql = "SELECT id, name FROM users WHERE age > 18 ORDER BY name ASC"
parsed = sqlparse.parse(sql)
for statement in parsed:
for token in statement.tokens:
print(token)
<Keyword 'SELECT' at 0x7f8c78203a38>
<Whitespace ' ' at 0x7f8c78203a70>
<Identifier 'id' at 0x7f8c78203a98>
<Operator ',' at 0x7f8c78203ac0>
<Whitespace ' ' at 0x7f8c78203ae8>
<Identifier 'name' at 0x7f8c78203b10>
<Whitespace ' ' at 0x7f8c78203b38>
<Keyword 'FROM' at 0x7f8c78203b70>
<Whitespace ' ' at 0x7f8c78203b98>
<Identifier 'users' at 0x7f8c78203cc0>
<Whitespace ' ' at 0x7f8c78203c08>
<Keyword 'WHERE' at 0x7f8c78203e20>
<Whitespace ' ' at 0x7f8c78203d30>
<Identifier 'age' at 0x7f8c78203e48>
<Whitespace ' ' at 0x7f8c78203e70>
<Operator '>' at 0x7f8c78203e98>
<Whitespace ' ' at 0x7f8c78203ec0>
<Number '18' at 0x7f8c78203ee8>
<Whitespace ' ' at 0x7f8c78203f10>
<Keyword 'ORDER' at 0x7f8c78203f48>
<Whitespace ' ' at 0x7f8c78203f80>
<Keyword 'BY' at 0x7f8c78203fa8>
<Whitespace ' ' at 0x7f8c78203fd0>
<Identifier 'name' at 0x7f8c78204050>
<Whitespace ' ' at 0x7f8c78204078>
<Keyword 'ASC' at 0x7f8c782040a0>
