I have highlighted this as well. The old data source was so simple so my boss made like 10 dashboards really quick with no knowledge about sql. However, as soon as you like to do aggregation you still need to use sql.