Mode is a mature home for hand-written SQL
Mode's workflow is built around the analyst as author. Write the query, add parameters that let a stakeholder switch the period or region, attach charts and commentary, then schedule it. Python and R notebooks are there when the analysis outgrows SQL. Mode has added an assistant that generates and explains SQL and summarizes results, but it speeds up the analyst rather than taking over the drafting.
That model is proven and predictable. Its limit is throughput: every new question passes through a person who writes SQL, so the backlog grows with demand. And since ThoughtSpot bought Mode in 2023, its direction is set inside a larger analytics company.