SQL Parsing library for Python [duplicate]
You might like to take a look at sqlparse
Blatantly stolen from their homepage:
>>> # Parsing>>> res = sqlparse.parse('select * from "someschema"."mytable" where id = 1')>>> res<<< (<Statement 'select...' at 0x9ad08ec>,)>>> stmt = res[0]>>> stmt.to_unicode() # converting it back to unicode<<< u'select * from "someschema"."mytable" where id = 1'>>> # This is how the internal representation looks like:>>> stmt.tokens<<<(<DML 'select' at 0x9b63c34>, <Whitespace ' ' at 0x9b63e8c>, <Operator '*' at 0x9b63e64>, <Whitespace ' ' at 0x9b63c5c>, <Keyword 'from' at 0x9b63c84>, <Whitespace ' ' at 0x9b63cd4>, <Identifier '"somes...' at 0x9b5c62c>, <Whitespace ' ' at 0x9b63f04>, <Where 'where ...' at 0x9b5caac>)>>>