Structured Query Language
Structured Query Language, usually shortened to SQL, is the standard way to talk to a Relational database without writing a novella about every row. It lets you query, insert, update, delete, and generally boss around data in systems like MySQL, PostgreSQL, and Microsoft SQL Server, which is why it has outlived several fashionable technologies that were sure they could do it better.
What it is, minus the ceremony
SQL is a declarative language. You describe the result you want, and the database decides how to get there, which is elegant right up until the optimizer gets ideas and becomes the smartest person in the room. That is why SQL is not a tiny programming language with a big ego, it is more of an instruction set for asking questions politely and getting answers fast.
The verbs that do the dirty work
Most people meet SQL through a handful of verbs: - SELECT fetches rows. - INSERT adds new rows. - UPDATE changes existing rows. - DELETE removes rows. - CREATE and ALTER shape tables and other objects. The language also handles filtering, sorting, grouping, joins, and aggregation, because apparently one syntax family was not enough of a commitment.
Why every database speaks it
SQL became the common dialect for relational databases, so vendors like MySQL, PostgreSQL, Oracle Database, and Microsoft SQL Server can argue about details while pretending they are all speaking the same language. The core language is standardized as ISO/IEC 9075, which is the sort of label only a committee could love, but it does at least keep the chaos inside the lines. The standard helps portability, but each system still brings its own quirks, extensions, and little acts of rebellion, because perfect compatibility would be far too civil.
The name had an identity crisis
SQL grew out of IBM's earlier SEQUEL work, then got shortened to SQL. So yes, the full phrase Structured Query Language is the expansion people use now, even though most humans just say SQL and move on with their lives. There is not really a competing meaning for the exact phrase, which is rare and comforting, like finding a working printer.
Riferimenti
- ISO/IEC 9075, Information technology - Database languages - SQL
- IBM, Structured Query Language: https://www.ibm.com/think/topics/structured-query-language
- Microsoft Learn, Structured Query Language (SQL): https://learn.microsoft.com/en-us/sql/odbc/reference/structured-query-language-sql?view=sql-server-ver17
- MDN Web Docs, SQL Glossary: https://developer.mozilla.org/en-US/docs/Glossary/SQL
- AWS, What is SQL?: https://aws.amazon.com/what-is/sql/