Personally I find Metabase lacks flexibility, but then again I think that’s just the predicament you’re stuck with in no-code/low-code.
What do you mean with lacks of flexibility? I've used MB for 5y+ and I've never found myself limited by the tool as long as I was able to connect the data source, that's IMHO the main friction with this tool
There is only so many things you can do with it is what I mean. You can’t make arbitrary graphs and you can only do very basic exploratory data analysis.
It’s great for cookie-cutter jobs, and for writing custom SQL, but not much more.
This! As long as you can connect the data source you can go quite forward with this tool. It's probably the one that have the quickest learning curve.
I love metabase. I'd also suggest to take a look at Apache Superset.