SQL - Structured Query Language

Implementations

SAS' propretiary implementation of SQL (Ansi 1999) is FedSQL.

TODO

BIRD

BIRD (BIg Bench for LaRge-scale Database Grounded Text-to-SQL Evaluation) contains over 12,751 unique question-SQL pairs, 95 big databases with a total size of 33.4 GB. It also covers more than 37 professional domains, such as blockchain, hockey, healthcare and education, etc.

Apparently, BIRD is related to Text-to-SQL parsing.

See also this link in this github repository.

sqllogictest

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.

Parsing SQL

libpg_query uses the actual PostgreSQL server source to parse SQL queries and return the internal PostgreSQL parse tree.

Presto (the distributed SQL query engine for big data) comes with a parser.

Malloy

Malloy is an experimental analytical language that provides the ability to define a semantic data model for describing and querying data relationships and transformations on SQL databases.

Malloy currently works with SQL databases BigQuery, Postgres, and querying Parquet and CSV via DuckDB.

Malloy was designed by a team of people with a lot of experience in understanding the task of extracting meaning from data. Years of constant exposure to SQL resulted in a tremendous sense of wonder at the power of SQL … and a tremendous source of frustration at how bad SQL is at representing the types of operations needed to get meaningful data out of relational databases, and how difficult it is to maintain and extend a complex set of transformations written in SQL.