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.