I strongly feel that if a domain language is not significantly more complex than the domain itself, then the person who is supposed to have domain knowledge should be able to learn the language without much difficulty. I've seen a lot of attempts to build 'simple' analytical systems without SQL, and it works well for simple queries -
but 'business people', when they're smart and motivated, soon start asking more and more specific and detailed questions, with additional conditions and joins - and it soon turns out that SQL is, in fact, an appropriate instrument for complexity that they need.
Your examples seem pretty simple. What about a question like this: how did our 5-week cohort (users that at the time of the event were registered between 4 and 5 weeks) ARPU vary over time and over character class they chose at registration? Is there a statistically significant corellation between participating in any of the 20 custom events we've done in the last half a year and user retention (which must be calculated relative to each users' cohort)?
Of course, a lot of business analysts are moving away from SQL to R, but I doubt that they're after simplicity.