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