"We support SQL on our distributed data platform" has to be the new big lie of distributed systems salespeople.

I'm not saying that computing joins, aggegates, sorts, etc can't be done in a distributed fashion, it just takes time, a lot of network reliability/reattempts, and understanding of the approximate nature of results if there are ongoing "eventually consistent" updates rolling through the cluster(s).