SQL parser library for Java

Question

Is there a good open-source Java library for parsing SQL statements?

If possible, it should be customizable or flexible enough to also be able to parse (or at least ignore) vendor-specific syntax (such as Oracle tablespace definitions or MySQL's LIMIT clause).

If not, strict adherence to the SQL standard is also fine.

Update: I need this for two things:

• providing an SQL interface to a non-SQL database (mapping to internal API calls)
• rewriting SQL before it goes to the actual database (e.g. Oracle)

Answer 1

ANTLR has an ANSI SQL grammar available. You can use that to create your own parser.

Answer 2

What you want to do with the parsed SQL? I can recommend a few Java implementation of Lex/Yacc (BYACC/J, Java Cup) that you can use an existing SQL grammar with.

If you want to actually do something with the resulting parsed grammar, I might suggest looking at Derby, an open source SQL database written in Java.

Answer 3

Parser

If you need a parser there should be a parser in the code base of Apache Derby.

Dealing with vendor-specific SQL

You may want to look at the .native() method on the jdbc Connection object which you can pass it vendor neutral queries that will get postprocessed into vendor specific queries.

Answer 4

jparsec

Answer 5

JSqlParser

Answer 6

Try Zql

Answer 7

Try http://jsqlparser.sourceforge.net/

Answer 8

Did you find a good solution? I want also to do some SQL rewriting...