REF :: for babel sql parser

[Cristian Vasile <cr...@gmail.com>]

Hello,

I feel that the babel extension of apache calcite is a very good
initiative. I would like to bring up some useful resources.

sql smith - the random sql generator
https://github.com/anse1/sqlsmith

real world Oracle queries:
https://github.com/oracle/analytical-sql-examples/tree/c5e889d4c0df3d3c2b2b9c3dfac543ec31986a14/SQL-Model/Scripts
https://github.com/oracle/analytical-sql-examples/tree/c5e889d4c0df3d3c2b2b9c3dfac543ec31986a14/analytical-sql/Scripts

other queries repositories
https://mifosforge.jira.com/wiki/spaces/MIFOS/pages/6258835/SQL+Query+Repository
https://wiki.koha-community.org/wiki/SQL_Reports_Library#Accounting_Reports_.28Fines.2FCredits.2FEtc.29

translator from/to various sql dialects
http://www.jooq.org/translate/

Hope this helps.

Regards,
Cristian.

REF :: Sqllogictest

[Cristian Vasile <cr...@gmail.com>]

Hello,

I remember that sqlite project (https://www.sqlite.org/index.html) do
have a very serious test process (https://www.sqlite.org/testing.html)
in place.
Quote
"Sqllogictest is a program designed to verify that an SQL database
engine computes correct results by comparing the results to identical
queries from other SQL database engines. Sqllogictest was originally
designed to test SQLite, but it is database engine neutral and can
just as easily be used to test other database products."

The link is here:
https://www.sqlite.org/sqllogictest/doc/trunk/about.wiki

Other technique is described here:
https://www.cockroachlabs.com/blog/testing-random-valid-sql-in-cockroachdb/

Hope this helps.

Regards,
Cristian.