in reply to SQL Parsing

Did you look at SQL::Statement? SQL::Statement::Structure documents how it parses SQL statements. I guess you might have to hack it a bit so it accepts your specific SQL database, but for relatively standard SQL queries, it should work.

Replies are listed 'Best First'.
Re^2: SQL Parsing
by axl4u82 (Initiate) on Feb 24, 2006 at 09:00 UTC
    SQL::Statement doesn't recognise table aliases, case statements and parameters i guess.
[reply]
      You're correct that it doesn't recognize case statements. It does recognize table aliases. I'm not sure what you mean by paramaters.
[reply]

In Section Seekers of Perl Wisdom