python_parse_sql.py

for parse sql statement with Python，like lex/yacc

output example:

select b,z,a from cuishou where b = 'k' and z > 6 and y = 5 order by b,z

['SELECT', ['b', 'z', 'a'], 'FROM', 'cuishou', 'WHERE', ['b', '=', 'k'], 'AND', ['z', '>', '6'], 'AND', ['y', '=', '5'], 'ORDER', 'BY', ['b', 'z']]

• and1_expr: ['z', '>', '6']
• and2_expr: ['y', '=', '5']
• columns: ['b', 'z', 'a']
• order_by_terms: ['b', 'z']
• table: ['cuishou']
• where_expr: ['b', '=', 'k']

Expected "SELECT"