[antlr-interest] sql parser implementation required?

[Peggy Fieland]

Kannan,

AFAIK there is no "general" SQL parser.
Also, every database has  its own variant of SQL.

Peggy

--- Kannan Ekanath <kannan.ekanath at gmail.com> wrote:

>  Hi, Level of Expertise : BEGINNER I am of the
> impression that antlr is some
> sort of a library generator for parsing some input
> based on some rules. In
> ANTLR the input is probably a "GRAMMAR" and the
> output is an archive/a
> library for parsing and saying if a string follows
> the grammar. Having said
> this, i also believe there must be a standard SQL
> ANTLR parser written by
> someone. If that is the case can someone point to
> those links? Basically i
> have a String in Java and i want to see if it is a
> valid SQL query (although
> some validations like whether the table is actually
> present in db cannot be
> done) and if it is a valid query i want to extract
> the bind parameters from
> that query. Can someone please point to relevant
> link? ANTLR seems to be a
> very broad parser implementation and i am searching
> if someone has written a
> "READYMADE" reusable SQL grammar.
> 
> PS : Cross posting at
> http://www.jguru.com/forums/view.jsp?EID=1273892
> 
> --
> Kannan Ekanath
>