I would honestly much rather have a powerful IDE where I write my own sql and my query output is visualized than any of this UI stuff.
I believe most data exploration just shouldn't be SQL/text based. It's just faster to do it visually if there aren't extra steps added and the interface is good/flexible enough.
Even as developers we spend most of our time in a GUI environment vs the command line. It's not just that it's easier/better for business users - it's also just better for everyone.
Totally the future is hybrid. Quickly press some buttons to get to a starting SQL and then go complex from there on if needed.
My principle is that “simple things should be simple, complex things are possible”