How to check SQL for authenticity from the command line?

Question

Is there a good tool to ensure that a SQL query is valid ANSI SQL and perhaps which DBMSs will not be able to interpret it? I found http://developer.mimer.com/validator , but I was wondering if there is a command line tool, preferably open source.

Answer 1

Here is the SQL Library to help you do vendor-specific SQL syntax checking offline through the command line, both Java and .NET were available.

Answer 2

Perhaps a parser / generator like ANTLR or JavaCC has an ANSI SQL 92 grammar already built. If so, you can run the parser / generator, build the classes that go out, and Bob your uncle.

I see that ANTLR has one based on Oracle PL / SQL. Maybe this can help you. ANTLR is a terrific tool worth knowing.