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.
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.
Built in 27
- PhpStorm Completion : Yes Go to definition : Yes Refactoring : Yes Debugging : No Tests : No Formatting : Yes
- IntelliJ IDEA Completion : Yes Go to definition : Yes Refactoring : Yes Debugging : No Tests : No Formatting : Yes
- PyCharm Completion : Yes Go to definition : Yes Refactoring : Yes Debugging : No Tests : No Formatting : Yes
- WebStorm Completion : Yes Go to definition : Yes Refactoring : Yes Debugging : No Tests : No Formatting : Yes
- Visual Studio With Data storage and processing workload (SQL Server Data Tools) Completion : Yes Go to definition : Yes Refactoring : Yes Debugging : Yes Tests : No Formatting : No
- GoLand Completion : Yes Go to definition : Yes Refactoring : Yes Debugging : No Tests : No Formatting : Yes
- CLion Completion : Yes Go to definition : Yes Refactoring : Yes Debugging : No Tests : No Formatting : Yes
- Rider Completion : Yes Go to definition : Yes Refactoring : Yes Debugging : No Tests : No Formatting : Yes
- RustRover Completion : Yes Go to definition : Yes Refactoring : Yes Debugging : No Tests : No Formatting : Yes
- RubyMine Completion : Yes Go to definition : Yes Refactoring : Yes Debugging : No Tests : No Formatting : Yes
- Android Studio With Room SQL support and Database Inspector Completion : Yes Go to definition : Yes Refactoring : No Debugging : No Tests : No Formatting : No
- Geany Completion : Yes Go to definition : Yes Refactoring : No Debugging : No Tests : No Formatting : No
- Apache NetBeans Completion : Yes Go to definition : No Refactoring : No Debugging : No Tests : No Formatting : No
- Eclipse IDE With Data Tools Platform (Enterprise Java and Web package) Completion : Yes Go to definition : No Refactoring : No Debugging : No Tests : No Formatting : No
- Vim Completion : Yes Go to definition : No Refactoring : No Debugging : No Tests : No Formatting : No
- Notepad++ Completion : Yes Go to definition : No Refactoring : No Debugging : No Tests : No Formatting : No
- Nova Completion : Yes Go to definition : No Refactoring : No Debugging : No Tests : No Formatting : No
- TextMate With SQL bundle Completion : Yes Go to definition : No Refactoring : No Debugging : No Tests : No Formatting : No
- Pulsar Completion : Yes Go to definition : No Refactoring : No Debugging : No Tests : No Formatting : No
- Helix Completion : No Go to definition : No Refactoring : No Debugging : No Tests : No Formatting : No
- GNU Emacs With sql-mode (SQLi) Completion : No Go to definition : No Refactoring : No Debugging : No Tests : No Formatting : No
- BBEdit Completion : No Go to definition : No Refactoring : No Debugging : No Tests : No Formatting : No
- Lapce Completion : No Go to definition : No Refactoring : No Debugging : No Tests : No Formatting : No
- Kate With SQL plugin Completion : No Go to definition : No Refactoring : No Debugging : No Tests : No Formatting : No
- Micro Completion : No Go to definition : No Refactoring : No Debugging : No Tests : No Formatting : No
- Kakoune Completion : No Go to definition : No Refactoring : No Debugging : No Tests : No Formatting : No
- GNU nano Completion : No Go to definition : No Refactoring : No Debugging : No Tests : No Formatting : No
Official extension 2
Community extension 8
- Devin Desktop With SQLTools Completion : Yes Go to definition : No Refactoring : No Debugging : No Tests : No Formatting : Yes
- Kiro With SQLTools Completion : Yes Go to definition : No Refactoring : No Debugging : No Tests : No Formatting : Yes
- Google Antigravity With SQLTools Completion : Yes Go to definition : No Refactoring : No Debugging : No Tests : No Formatting : Yes
- TRAE With SQLTools Completion : Yes Go to definition : No Refactoring : No Debugging : No Tests : No Formatting : Yes
- VSCodium With SQLTools Completion : Yes Go to definition : No Refactoring : No Debugging : No Tests : No Formatting : Yes
- Neovim With vim-dadbod, vim-dadbod-ui, vim-dadbod-completion Completion : Yes Go to definition : No Refactoring : No Debugging : No Tests : No Formatting : No
- Sublime Text With LSP (manual Postgres Language Server config) Completion : Yes Go to definition : No Refactoring : No Debugging : No Tests : No Formatting : No
- Zed With SQL (zed-extensions/sql) Completion : No Go to definition : No Refactoring : No Debugging : No Tests : No Formatting : No
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
- 1986 SQL-86 First standard, adopted by ANSI and in 1987 by ISO.
- 1992 SQL-92 Major revision with new joins, more data types and schema manipulation.
- 1999 SQL:1999 Added recursive queries, triggers, procedural control flow and some object-oriented features.
- 2003 SQL:2003 Added window functions, sequences, identity columns and XML features.
- December 2011 SQL:2011 Added temporal tables with application time and system versioning.
- December 2016 SQL:2016 Added JSON functions, row pattern recognition and polymorphic table functions.
- June 2023 SQL:2023 Added a native JSON type and Part 16 for property graph queries (SQL/PGQ).
Sources
Last checked: 20 November 2026