Metadata
- Author: SPLWare
- Full Title:: SQL Looks Like English Is a Well Intentioned Error
- Category:: 🗞️Articles
- URL:: https://github.com/SPLWare/esProc/wiki/SQL-looks-like-English-is-a-well-intentioned-error
- Finished date:: 2024-03-09
Highlights
The true advantage of natural language lies in its ambiguity, which allows it to accept less strict syntax to a certain extent. However, SQL does not support this feature, and it was not possible to achieve this feature in the era when SQL was invented. (View Highlight)
But this is something fixed with CTEs
Not advocating for step-by-step can lead to long single SQL statement. The complex SQL statements faced by programmers are rarely counted in lines, often in Ks. However, for the same 100 lines of code, whether it is divided into 100 statements or only 1 statement, its complexity is not at the same level at all. This type of code is very difficult to understand, and once it was finally written, after two months, the programmer himself couldn’t understand it. Moreover, the single long statement without steps is difficult to debug, and the development cycle is also longer. (View Highlight)