Try it online now! - A full parser with Abstract Syntax Tree for the T-SQL 2005 specification. Written with ANTLR 3.1 and targeted for C, Java and C#. Provides parsing, production of an AST and AST parser, ready for inserting your own application/systems code.

Parsing SQL is a notoriously difficult task because the syntax is very ambiguous in a lot of places. Many people have attempted to write a full SQL grammar with ANTLR and failed.

This product will provide you with a full SQL parser (initially Microsoft T-SQL as per SQL Server 2005, but soon to include Oracle, DB2 and perhaps others), which will produce an Abstract Syntax Tree (AST), and a Tree Parser to navigate the resulting AST. The product also provides a generator API (you are free to use your own coded actions of course, should you prefer.) In short, this should be everything you need to produce anything from a syntax analyser, formatter, meta-data constructor, or even a full on SQL engine, syntactically compatible with the major variants (though you need to supply your own query engine).

Licensed via a one off, royalty-free payment that includes full source code, for $12,000 USD.