>>> from sqlparser import parse
>>> parse("select * from blog where name='zhangsan';")
{
'type':'SELECT',
'column':[{'name':'*'}],
'table':[{'name':'blog'}],
'join': [],
'where':[{'name': 'name', 'value': 'zhangsan', 'compare': '='}],
'group':[],
'having':[],
'order':[],
'limit':[]
}
See test_parser.py for more information