[jalk]

Common Table Expressions (CTE) do help a little, as you can query each “table” and inspect the output. Debugging a giant query with deeply nested sub queries is very painful indeed

[Ma8ee]

So do table variables and temp tables.