4 ms·
What about the main point of the article that SQL is not composable.
by nendroid 6y ago
What about the main point of the article that SQL is not composable.
- jmalicki 6y agoCTEs (common table expressions) and views definitely do help with this, though they are new-ish where they exist and often have optimization issues. But being able to use them extensively in a newer database where they work well helps this quite a bit.
- nendroid 6y agoTables are composable but the expression itself cannot be decomposed. I cannot reuse a where clause somewhere else; that is the fundamental problem the article addresses.