[revenga99]

I'm currently in the middle of building an overly complicated analytics platform where there is a "easy mode" and an "advanced mode" they pick the devices and metrics they want on the graph, and if they toggle advanced it shows the sql it used to create the graph. So then they can edit the sql or do whatever they want.

Giving customers "secure" sql access was a must have feature from upper management, and it was very tricky/a nightmare to get right.

Customers actually liked it though, sql is king.

Advise I would give is make sure your analytics api's data models and queries are well though out and extensible. It makes it very hard to change them and rework the ux.