My startup seriously evaluated Metabase, but inevitably you'll want joins, and Metabase is fundamentally opposed to the idea: https://metabase.com/blog/Joins/ ... and if you're writing SQL for your views, you might as well be writing SQL.

We ended up shelling out for Tableau - it's pricey at $840/yr, but it supports joins out of the box (it even has a drag-and-drop interface to set up joins!), has practically every bell and whistle you could ask for, and allows you to do "exploratory analysis over screenshare in realtime with non-technical colleagues, without context switching to a coding mindset or needing to look up field names you may never have used before." I think it's intuitive and worth every penny, but YMMV. Would recommend everyone try the public version to get a feel for it.

EDIT: as others have said, Ananas is actually ETL + BI, whereas Metabase and Tableau are BI on top of a database. Tableau can stand in for good ETL due to its join support in certain scenarios. It's better than Metabase, but not necessarily comparable to Ananas.