4 ms·
> The problem with SQL is that it is not a (very) composable language. I thought the same until a few weeks ago. Then we used the WITH operator for pre-process
by interleave 3y ago
> The problem with SQL is that it is not a (very) composable language.
I thought the same until a few weeks ago. Then we used the WITH operator for pre-processing and giving things human-readable names.
That helped us manage complexity. The final SELECT statement was very easy to reason about.
Not sure if this is a best (or worst) practice but it helped us ship it.