SQL uses nesting as you have shown instead of a "pipe" (think of it like functional programming).

The difference is just the syntax, not the expressiveness.