SQL is the acronym for Structured Query Language whether or not you think it is. It is not a misnomer.
It is structured. Structured in this sense is referring to standardization by ANSI and ISO.
Well, if they meant structured in that sense, why didn't they use "Standardized"? It wouldn't even ruin the "acronym".
SQL is a fully implemented "Query Language". It is "Structured" "Query Language" not "Structured" "Query" "Language". So in this regard it is a full database language.
SQL is limited to queries. Don't confuse SELECT (data retrieval) as the only form of a query. There are five: SELECT, WHERE, UPDATE, DELETE, and INSERT. All database operations can be reduced to one of these five queries.
Weeell, first of all, you're forgetting FROM. And while WHERE may be a clause in a statement, it is certainly not the most crucial part, and certainly cannot form its own statement. UPDATE, DELETE, and INSERT are also not queries. A query returns information from one or more tables. Since when did those three statements return any rows from a table? And if those "queries", as you say, are all there are to SQL, then, my friend, we are up the creek without a paddle. For it would be most difficult to actually create a database in the first place. It would also be rather difficult to create or alter a table, now wouldn't it? And creating indices and views would most certainly be impossible, would it not?
While attempting to explain "query" and "language" by saying it is a "query language" is convenient, it is also not true, as I've demonstrated that there is
more to SQL than the SELECT statement. It is
, however, a database language. It is also a declarative language. But it is not a "query language".
And as the final nail in the coffin, I shall quote from an SQL reference book:
Chris Fehily wrote:
It's a common misconception that SQL
stands for structured query language
; it stands for S-Q-L and nothing else. Why? Because ANSI says so. The official name is Database Language SQL... Furthermore, referring to it as a structured query language is a disservice to new SQL programmers; it amuses database professionals and academics to point out that "structured query language" is the worst possible description, as SQL:
- Isn't structured (because it can't be broken down into blocks or procedures)
- Isn't limited to only queries (that is, there's more than just the SELECT statement)
- Isn't a complete language (according to Turing's Thesis, which you'll study should you take Theory of Computation)
SQL may have used
to have been called "structured query language", but as of the ANSI standards, it is not.