I have a task to parse/validate SQL to check SQL syntax.

 

Jsqlparser http://mvnrepository.com/artifact/net.sf.jsqlparser/jsqlparser/0.8.0
JSQLparser GitHub: https://github.com/JSQLParser/JSqlParser

 

ANTLR Maven Plugin
http://www.antlr.org/api/maven-plugin/latest/index.html

• antlr github home
  https://github.com/antlr/antlr4
• SQLite grammar
  https://github.com/antlr/grammars-v4/tree/master/sqlite
• http://stackoverflow.com/questions/15324837/how-do-i-get-help-on-the-antlr4-maven-plugin
• http://mysqlworkbench.org/2015/08/parsing-in-mysql-workbench/

 

SQLparser.com (commercial)
http://www.sqlparser.com/

• http://www.dpriver.com/blog/list-of-demos-illustrate-how-to-use-general-sql-parser/vendor-specific-offline-sql-syntax-check/
• Blog that I have found SQLparser.com http://stackoverflow.com/questions/141499/any-java-libraries-out-there-that-validate-sql-syntax

 

Miner Validator (Shareware with license limitation)
http://developer.mimer.se/index.htm

Blogs

• How can I check (My)SQL statements for syntactical correctness – found Miner validator
  http://stackoverflow.com/questions/3970643/how-can-i-check-mysql-statements-for-syntactical-correctness