As an engineer myself who likes to dig into data/analytics, writing and tweaking some of the complex SQL is not that easy or fun. I am impatient to get to the insights.

I imagine SQL would be harder and more annoying for biz folks. A programmer might be right "expert" to get the SQL working (Usually the programmer itself is a generalist when trying to write SQL for analytics).

A text-to-SQL tool will help create the queries quickly; it is much easier for an engineer to verify the generated queries and the results of those queries.