Regular Expression library/set to parse sql

Question

Anyone know of any re libraries out there to help parse columns, functions, and values from an SQL WHERE clause?

Example strings:

COLUMN=='VALUE'
COLUMN=='VALUE' AND COLUMN2='VALUE'
FUNCTION(COLUMN)==FUNCTION('VALUE')

I'm working in Python, but can port most anything over...

Answer 1

Perhaps this SO question and its answers will help (Parsing SQL with Python).

Here are a couple of links that may help.