prestodb/sql

2000+ Real Life SQL Samples + stress tests

manticore-projects opened this issue · 1 comments

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

Check this out. While it is not supported anymore (I don't think), this was built by NIST!

https://github.com/itisaid/NIST4Hive