Extracted from another, RDBMS agnostic SQL Parser.
Some of the examples may be less interesting (e. g. MySQL specific syntax). However, in my opinion any practically useful Parser should at least understand common Oracle, MS SQL Server, DB2, PostgreSQL (the big four).
Do let me know, if you want those tests incorporated and what triage criteria (necessary, nice to have, out-of-scope) should be applied. While I do love standards, sadly there is no single pure and relevant SQL:2016 RDBMS outside.
SQLSamples.zip
Extracted from another, RDBMS agnostic SQL Parser.
Some of the examples may be less interesting (e. g. MySQL specific syntax). However, in my opinion any practically useful Parser should at least understand common Oracle, MS SQL Server, DB2, PostgreSQL (the big four).
Do let me know, if you want those tests incorporated and what triage criteria (necessary, nice to have, out-of-scope) should be applied. While I do love standards, sadly there is no single pure and relevant SQL:2016 RDBMS outside.
SQLSamples.zip