A long query written with CTEs is eminently more readable than the logically equivalent query written with nested sub-queries. Just like a pipe operator makes

A long query written with CTEs is eminently more readable than the logically equivalent query written with nested sub-queries. Just like a pipe operator makes long strings of function calls more readable than the semantically identical nested function calls.