search

prestodb / sql

A Modern SQL frontend based on SQL16 with extensions for streaming, graph, rich types, etc, including parser, resolver, rewriters, etc.
Apache License 2.0
10 stars 11 forks source link

2000+ Real Life SQL Samples + stress tests #42

Open manticore-projects opened 1 year ago

manticore-projects commented 1 year ago

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

kaikalur commented 1 year ago

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

https://github.com/itisaid/NIST4Hive