Your favorite SQL parser/tokenizer

[MicahCarrick]

I have a project in which a fairly accurate yet light weight parser for MySQL SELECT statements is needed. I would really prefer not to write this myself.

 

I simply need to be able to parse a SELECT statement into it's components so that the code can manipulate it. It needs to handle any sane SELECT query and various database-specific options (or at least know that it doesn't understand the options).

 

So, I've done some Googling and there are some neat projects out there, but, I wanted to get some opinions on you folks' experience with SQL parser. Any suggestions?