NEEDED: SQL Parser callable from python?

[Simon Brunning]

> From:	mkent at atlantic.net [SMTP:mkent at atlantic.net]
> I'm working on a python interface to a home-grown legacy flat-file
> database.
> I've gotten to the point where I'm considering adding an SQL layer to the
> API.
> Can anyone give me a pointer to an open source SQL parser callable from
> python?
> I will need to use it to translate standard SQL into python code callbacks
> 
> to the functions/methods specific to the legacy DB API.
 
How about giving SimpleParse a bash? SimpleParse is here -
<http://members.rogers.com/mcfletch/programming/simpleparse/simpleparse.html
>, and you can find a BNF grammar for SQL here -
<http://www.contrib.andrew.cmu.edu/~shadow/sql/sql2bnf.aug92.txt>.

Good luck, and tell us how you get on. ;-)

Cheers,
Simon Brunning
TriSystems Ltd.
sbrunning at trisystems.co.uk




-----------------------------------------------------------------------
The information in this email is confidential and may be legally privileged.
It is intended solely for the addressee. Access to this email by anyone else
is unauthorised. If you are not the intended recipient, any disclosure,
copying, distribution, or any action taken or omitted to be taken in
reliance on it, is prohibited and may be unlawful. TriSystems Ltd. cannot
accept liability for statements made which are clearly the senders own.