title: should I use ANTLR to transform simple SQL select statements?
body: <p>I need to write a program that accepts a basic SQL select statement and outputs an XML file which breaks down the statement into it's component parts (the output columns, the input tables, the join, group by, aggregations, etc.). At a minimum I need to support 2 tables in the from statement, different join types, where clause, group by and having. If more complex sql can be supported (e.g. subqueries) that's a bonus, but not necessary. </p>
  
  <p>I checked out ANTLR and it looks like a steep learning curve. Given that I have the ability to require the SQL to be fairly simple, should I attempt to hand code or should I embark on the world of ANTLR?</p>