> A bookmarkable interface for executing read-only SQL queries against your database
We use Metabase at my work and I love it. It handles visualizations out of the box and I can write SQL like my heart desires, while still being able to help out our designers, customer success, and sales needs. Their "questions" (what they call a query) can be parameterized and added to dashboards and everything works so well.
Also one of the few large projects I see that's written in Closure.
This wouldn't be possible in a lot of the projects I work on.
The problem is privileges -- for example, the data you can see depends on whether you're logged in or not, and your group and role when logged in.
What I've done instead is provided an interface (bookmarkable) to a set of "rowsets", where the rowset has a name and set of columns, where the columns are filterable, sortable, and/or selectable. Directly behind the rowset is SQL, of course (and/or a view or table), so it's not that much less flexible than SQL directly, but it provides a point where additional filter conditions can be reliably added to enforce privileges (there's also a dev option to see the SQL, if that's needed).
We use Metabase at my work and I love it. It handles visualizations out of the box and I can write SQL like my heart desires, while still being able to help out our designers, customer success, and sales needs. Their "questions" (what they call a query) can be parameterized and added to dashboards and everything works so well.
Also one of the few large projects I see that's written in Closure.