Is there an ANTLR grammar for just the where clause of an ANSI SQL query

[lalwani...@gmail.com]

I don;t need a full SQL parser, just the where clause.

More specifically, I'm trying to build something that can parse a where clause and convert it into an Excel formula. The Excel sheet has named cells corresponding to the database columns. So, I want to be able to do something like parse a where clause "ColA > 20 and ColB='XXX'" into "=AND(ColA>20,ColB="XXX")". Anyone know if there is a OTS soultion for this?

[Mike Lischke]

> I don;t need a full SQL parser, just the where clause.
>
> More specifically, I'm trying to build something that can parse a where clause and convert it into an Excel formula. The Excel sheet has named cells corresponding to the database columns. So, I want to be able to do something like parse a where clause "ColA > 20 and ColB='XXX'" into "=AND(ColA>20,ColB="XXX")". Anyone know if there is a OTS soultion for this?

Seems you are after a normal expression parser. Keep in mind however that a where clause can include table and column references as well as subqueries and special language constructs. For instance in MySQL you can have match, case and cast expressions. For which SQL dialect do you look for an expression parser?

Mike
--
www.soft-gems.net