Hi Fletch,
I was very optimistic regarding your idea.
I read the doc and did some tests with SQL::Statement.
Unfortunately it seems not to be straightforward:
Using this code: 
select
some_table.a_column,
some_table.a_2ndcolumn
FROM
some_table 
UNION 
select
another_table.a_3rdcolumn,
another_table.a_4thcolumn
FROM another_table
WHERE
some_table.a_date_column <=  to_date('20071111', 'YYYYMMDD') AND
some_table.a2nd_date_column  >=  to_date('20071111', 'YYYYMMDD')
}

[download]
I couldnt get all columns identified and it doesnt seem to recognize the UNION join (by the way I'm using SQL ORACLE syntax).
So I've the impression that one should make extensive customization work in order to get it really do the work.
In this case I would preferably stay with Parse::RecDescent
Don't you know about some SQL query parsing example with parse-recdescent?
Anyway many thanks
Davide.

In reply to Re^2: SQL Parsing with Parse::RecDescent by DACONTI
in thread SQL Parsing with Parse::RecDescent by DACONTI

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.