SQL Conformance Levels

The SQL standard is huge. More than 4300 pages in its SQL:2016 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 conformance.1 Most database just conform to entry-level.2

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 features.3

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

About the Author

Photo of Markus Winand

Markus Winand is the SQL Renaissance Ambassador. He is on a mission to introduce developers to the evolution of SQL in the 21st century. Markus can be hired as trainer, speaker and consultant via winand.at.

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

Markus offers SQL training and consulting for developers working at companies of any size.
Learn more »



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.”


SQL-92, §23.2


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


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

Connect with Markus Winand

Markus Winand on LinkedInMarkus Winand on XINGMarkus Winand on Twitter
“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 and GDPR | CC-BY-NC-ND 3.0 license