Our users (researchers) had no problems learning the concepts of querying but didn't want to be bothered learning SQL syntax - hence we built this (also, our system does quite a bit of magic behind the scenes to allow mixing e.g. CSV data with data from a database, and also allows for things not easily done in SQL, e.g. pivot tables, so it's not just SQL).
As someone who works in BI I am mighty impressed! I don't think I have seen a tool pack as much power in a fairly easy to follow manner. My 8 year older daughter picked up Scratch[0] after the briefest of intros. You application reminds of Scratch.
Yes, the demo was definitely made using the production system! (Although usually our ‘puzzles’ are quite a bit more complicated than this simple coffee example. Although more often than you expect, simply publishing a small CSV with a bit of filtering is sufficient!)
Our users (researchers) had no problems learning the concepts of querying but didn't want to be bothered learning SQL syntax - hence we built this (also, our system does quite a bit of magic behind the scenes to allow mixing e.g. CSV data with data from a database, and also allows for things not easily done in SQL, e.g. pivot tables, so it's not just SQL).