Chapter 18. Procedural and Data-Driven Solutions
WE USED TO joke that SQL stands for “Scarcely Qualifies as a Language” because it lacks input and output formatting as well as special functions that other languages have to do particular jobs. What is forgotten is that SQL is a data management language, and it was never meant to do certain jobs.
Statistical and mathematical packages can handle floating-point rounding errors and provide libraries of complex functions. String and document base languages can search and manipulate character data far faster and easier than SQL. The only data structure in SQL is a multiset, so you cannot easily do operations that involve arrays.
This does not mean that you cannot do some of these things in SQL; but ...
Get Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
