How does it work with parameterized filtering, time intelligence, etc ? Does the user have to modify the script or can they do it through point and click UI.
It's not quite point and click, although I've implemented Tableau like frontends on Qt/javascript which construct a pivot description, and then get compiled using SQLAlchemy core into a sql query that drives the DB. Still working out the best UX to expose to the user, but I think I'll go the approach of Mode since our users are sophisticated enough to write analytic SQL.