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...

Community · Accepted Answer · 2017-05-23 12:30:45Z

1

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

Here are a couple of links that may help.

CommunityBot

11 silver badge

answered Apr 2, 2010 at 9:53

Oded

501k102 gold badges900 silver badges1k bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1