{
  "$type": "site.standard.document",
  "bskyPostRef": {
    "cid": "bafyreifqnetloka52lvkcrek5eyjrnk5prcqyplo4pak23y4a2p27gtxiq",
    "uri": "at://did:plc:5sgu76a53rz3n6unbykmovqy/app.bsky.feed.post/3mloh62fp4ss2"
  },
  "description": "SQL (Structured Query Language) is the declarative language for defining, querying, and manipulating relational databases. Despite decades of speculation about its replacement, SQL remains the dominant data interface across analytics, transactional systems, and increasingly across distributed and embedded databases.\n\n\nStatement categories\n\n * DDL (Data Definition Language): CREATE, ALTER, DROP for schemas, tables, indexes\n * DML (Data Manipulation Language): SELECT, INSERT, UPDATE, DELETE\n * DCL",
  "path": "/engineering-glossary/sql-structured-query-language/",
  "publishedAt": "2026-05-12T18:46:26.000Z",
  "site": "https://sahilkapoor.com",
  "tags": [
    "PostgreSQL",
    "MySQL",
    "ACID",
    "MVCC",
    "NoSQL",
    "OLTP",
    "The Cost of SQL Habits on MongoDB Infrastructure"
  ],
  "textContent": "**SQL (Structured Query Language)** is the declarative language for defining, querying, and manipulating relational databases. Despite decades of speculation about its replacement, SQL remains the dominant data interface across analytics, transactional systems, and increasingly across distributed and embedded databases.\n\n## Statement categories\n\n  * **DDL (Data Definition Language):** `CREATE`, `ALTER`, `DROP` for schemas, tables, indexes\n  * **DML (Data Manipulation Language):** `SELECT`, `INSERT`, `UPDATE`, `DELETE`\n  * **DCL (Data Control Language):** `GRANT`, `REVOKE` for permissions\n  * **TCL (Transaction Control Language):** `BEGIN`, `COMMIT`, `ROLLBACK`, `SAVEPOINT`\n\n\n\n## SQL dialects\n\nThe SQL standard is large; every database implements a subset and adds its own extensions. The differences matter most around: data types, window functions, recursive CTEs, JSON support, upsert syntax, and array handling.\n\n  * **PostgreSQL.** The closest mainstream implementation to the standard, with rich extensions.\n  * **MySQL.** Widely deployed; more permissive defaults; InnoDB engine.\n  * **SQLite.** Embedded; surprising amount of SQL coverage; default for many applications.\n  * **SQL Server, Oracle.** Enterprise heavyweights with proprietary extensions (T-SQL, PL/SQL).\n  * **Distributed SQL.** CockroachDB, Spanner, TiDB, YugabyteDB run SQL across horizontally scaled clusters.\n\n\n\n🔗\n\n**Related Terms**\nPostgreSQL, MySQL, ACID, MVCC, NoSQL, OLTP\n\n📖\n\n**Further Reading**\nThe Cost of SQL Habits on MongoDB Infrastructure",
  "title": "SQL",
  "updatedAt": "2026-05-13T19:11:07.443Z"
}