Addi Jamshidi wrote:
I am looking for a way to parse a given SQL statement and as output to received the parsed tree so I can in turn present that as XML. Basically given a SQL statement I would like to parse it and get its parsed tree in terms of XML.
Others have asked about this. I'm cc'ing the [EMAIL PROTECTED] list in case someone's already made such a module.
Does your SQL Parser make it possible for me to do this?
With limitations, yes. It only does a small subset of SQL, but what it does it can return as hash that could easily be used to generate XML.
Also is your SQL Parser flexible to allow adding to the grammer to for example support DB2 SQL, etc., etc.?
It should be. Where it isn't, I'm certainly willing to make it so.
One point: I need this parser to run under MS .NET framework (i.e. no Java virtual machine).
You're out of my depth there, I don't know much about .NET or Java. You do know my module is a Perl module? But I hear .NET does Perl so maybe you can get it work under .NET. Since SQL::Parser is pure perl (no C code) it should be one of the easier ones to get working under .NET. If you do that, please let me know.
Thank you so much in advance for any info you can provide (including licensing, etc.).
It's licensed under either the GPL or the Artistic License (which is open source but allows use in proprietary products under most circumstances).
-- Jeff
