SQL Conformance Levels


The SQL standard is huge. More than 4000 pages in its SQL:2011 incarnation. No single implementation can ever implement all features.0 Even in the early releases, such as SQL-92, the SQL standard defined different conformance levels so that vendors can claim conformance to a subset of the standard.

Conformance Levels in SQL-92

SQL-92 defines three conformance levels: entry, intermediate and full. Conformance claims must state to which level they are claiming conformance1. Most database just conform to entry-level2.

Optional Features since SQL:1999

Starting with SQL:1999 all features are enumerated and either flagged mandatory or optional. As a bare minimum, conforming systems must comply with all mandatory features, which are collectively called “Core SQL”. Besides entry-level SQL-92 features, Core SQL:1999 also requires some features previously only required for intermediate or full level as well as a few new features3.

Beyond Core SQL, vendors can claim conformance on a feature-by-feature basis.

About the Author

Photo of Markus Winand

Markus Winand teaches efficient SQL—inhouse and online. He minimizes the development time using modern SQL and optimizes the runtime with smart indexing. His book entitled SQL Performance Explained has become standard reading.

Buy his Book on Amazon

Cover of “SQL Performance Explained”: Squirrel running on grass

The essence of SQL tuning in 200 pages

Buy on Amazon
(paperback only)

Paperback and PDF also available at Markus’ store.

Hire Markus

…to answer your current SQL questions.

The quick and easy way to benefit from his extensive knowledge and experience.
Learn more »

Footnotes

0

Unproven claim for dramatic effect. However, in his paper “Is SQL a real standard anymore” the former secretary of the ANSI committee on databases writes that implementing Core SQL:1999 “is close to impossible for all vendors except for two of three.”

1

SQL-92, §23.2

2

According to my observations but also stated in the PostgreSQL documentation.

3

“SQL in a Nutshell” by Kevin Kline [ISBN: 978-0-596-51884-4].

“modern SQL” by Markus Winand is licensed under a Creative Commons Attribution-Noncommercial-No Derivative Works 3.0 Unported License.
Legal | Contact | NO WARRANTY | Trademarks | Privacy | CC-BY-NC-ND 3.0 license