About a month ago, I built an application using zSQL as an SQL parser to parse sql. However, just a few days ago, the user performing the interception function was sent to instructions for inserting multiple rows, which zSQL does not support. That's an example:
INSERT INTO MyTable (FirstCol, SecondCol)
SELECT 'First' ,1
UNION ALL
SELECT 'Second' ,2
UNION ALL
SELECT 'Third' ,3
UNION ALL
SELECT 'Fourth' ,4
UNION ALL
SELECT 'Fifth' ,5
Then I found this link: http://weblogs.java.net/blog/2008/11/23/stand-alone-sql-parser-java , it says: "With a simple fix, Rick Hillegas ensured that developers can have access to the powerful SQL parser that comes with Apache / Derby. " However, I cannot find the relevant documentation for this.
Any idea?