<p>I'm not sure if this even exists or not, so I figured I would tap the wisdom of others.. </p>

<p>I was wondering if there are any Java libraries out there that can be used to validate a SQL query's syntax. I know that there are many deviations from common SQL spec, so it would probably only work against something like SQL:2006, but that would certainly suffice. </p>

<p>My goal is to use this for unit-testing purposes without needing to attempt the execution against the DB. I know it's of limited use, but it would still be useful. </p>

<p>Thanks!</p>

I don't think there are such libraries. The SQL syntax has too many derivatives.
A possible solution would be to use parts of an open source pure Java DBMS like
SmallSQL
. In this project you can create an instance of the
SQLParser
. The needed references to the connection can be removed very easily.