Lots of the examples here are yhe author writing very poor, non idiomatic SQL and then criticizing it.
I could write a point by point rebuttal but I'll just pick one point, compressibility: VIEWs.
I could write a point by point rebuttal but I'll just pick one point, compressibility: VIEWs.
But just give up, you hit the wall. Many people tried for decades to make this argument, but every time it was raised you’d see this thread full of people who see no problems. There is a lot of powerful, unrepeatable-in-your-lifetime software behind stupidest frontends that you can’t bypass, because most people write only straightforward code with no need for any abstractions beyond what was given to them.