SQL Standard

ISO/IEC 9075 is the formal name for what is more colloquially known as the SQL standard. Every few years a new version is published.

Each version is split into multiple parts. Part 2: Foundation (SQL/Foundation) is the largest part (in terms of pages) and covers the syntax and behavior for the core SQL language. It’s also the most relevant part for this project.

vsql works against SQL:2016 (ISO/IEC 9075-2:2016), and Part 11: Information and Definition Schemas (SQL/Schemata) (ISO/IEC 9075-11:2016) for the INFORMATION_SCHEMA. The source files are named after the part and section of the standard that they implement (such as std_2_14_14_update_statement_searched.v for Part 2, section 14.14), and SQL Compliance lists which features are supported. Most of the features in common use were published by 2003, so older versions (such as 1999) are still relevant and helpful because they contain most of the core features.

Unfortunately, the SQL Standard is not free (and is very expensive). This includes all previous versions. This is obviously a challenge for an open-source project. While we cannot include a copy of the standard, the next best option is to provide a list of locations where it exists: