Hey thanks for mentioning Metabase, I work there. Not to hijack this thread, but I'm happy to answer any questions.
We do have raw SQL (and Mongo/Druid/etc) mode if that's your preference, or if you can't express something in our graphical query builder.
There's also a neat little feature that will translate your query builder query to the equivalent SQL to use as a starting point if you can't express something using the UI.
We also have parameters so you can parameterize questions (both graphical and SQL) on a dashboard.
Finally, we recently started added permissions and groups, so Metabase will be able to grow with your company. A lot more to come there too.
We do have raw SQL (and Mongo/Druid/etc) mode if that's your preference, or if you can't express something in our graphical query builder.
There's also a neat little feature that will translate your query builder query to the equivalent SQL to use as a starting point if you can't express something using the UI.
We also have parameters so you can parameterize questions (both graphical and SQL) on a dashboard.
Finally, we recently started added permissions and groups, so Metabase will be able to grow with your company. A lot more to come there too.