editors.dev

SQL

SQL is the standard language for defining, querying and changing data in relational databases. It is standardised as ISO/IEC 9075, and nearly every relational database system implements a dialect of it.

Actively developed First released 1974

Editors for SQL

37 editors and IDEs support SQL. Built in first, then official and community extensions. Each row opens the editor at its SQL notes.

Filter the editor list

Built in 27

Today

SQL:2023 (ISO/IEC 9075:2023) is the current edition. The committee published corrigenda to some of its parts in 2026, and drafts for the next edition, including Part 2 (Foundation), are at the committee draft stage, with no publication date set. Database systems such as PostgreSQL, MySQL, SQLite, Oracle Database and SQL Server each follow the standard to a different degree. In the Stack Overflow Developer Survey 2026, 58.4 percent of respondents reported using SQL.

What it is used for

Querying and managing data in relational databases such as PostgreSQL, MySQL, SQLite, Oracle Database and Microsoft SQL Server, and in analytics engines and data warehouses.

History

Donald D. Chamberlin and Raymond F. Boyce designed SEQUEL at IBM in the early 1970s, building on Edgar F. Codd's relational model, and described it in a 1974 paper. The name was later shortened to SQL because SEQUEL was a trademark of another company. Relational Software, Inc., now Oracle, shipped one of the first commercial SQL databases, Oracle V2, in 1979.

ANSI adopted SQL as a standard in 1986 and ISO followed in 1987. SQL-92 was a large revision that most database systems still treat as their core. SQL:1999 added recursive queries, triggers and procedural code, and SQL:2003 added window functions and XML support.

Later editions followed the needs of the time: temporal tables in SQL:2011, JSON functions and row pattern recognition in SQL:2016, and a native JSON type plus property graph queries (SQL/PGQ) in SQL:2023.

Milestone versions

  1. 1986 SQL-86 First standard, adopted by ANSI and in 1987 by ISO.
  2. 1992 SQL-92 Major revision with new joins, more data types and schema manipulation.
  3. 1999 SQL:1999 Added recursive queries, triggers, procedural control flow and some object-oriented features.
  4. 2003 SQL:2003 Added window functions, sequences, identity columns and XML features.
  5. December 2011 SQL:2011 Added temporal tables with application time and system versioning.
  6. December 2016 SQL:2016 Added JSON functions, row pattern recognition and polymorphic table functions.
  7. June 2023 SQL:2023 Added a native JSON type and Part 16 for property graph queries (SQL/PGQ).