Despite that, I'm not convinced that SQL syntax sucks, and certainly not convinced by the specific rollup example in the blog post.
Personally, I find SQL easy to understand and flexible enough to achieve any result.
I haven't heard of Malloy before today, but to me the syntax just seems... different, not better. Maybe for someone who hasn't learned SQL yet, it would be better? I don't know, but have my doubts about that.
I'm not trying to say Malloy is bad (I haven't used it!), just that coming in with "SQL syntax sucks" seems like not a winning approach.