Non-techies wielding SQL is a big advantage for sure, but a moderately complex dataset sends SQL aggregations complexity through the roof. While modern data warehouses can handle such queries, I can hardly imagine non-technical person being able to write it.

That's where dashboards come in handy.