We have been using something like this based on Blockly in production for over seven years now to build dashboards. GIF demo: https://www.dialogic.nl/wp-content/uploads/2018/02/demo1.gif
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.