>"It's often more complicated than that and doing it in a non-sql way is suboptimal/unmaintainable."
It's also more composable, if you ask me. I like to think of it like "building" SQL statements using smaller components. Just like you do with code, you essentially compose a complicated business process using smaller blocks.
It's beautiful in it's simplicity. Even if the syntax requires some extra work/learning.