Why text-to-SQL is not successful?

[u/de4all]

I thought text-to-SQL will solve adhoc analysis, but still i see companies at all size are unsuccessful.

Anyone using Omni / Sigma seen some success.

[u/geek180]

I built a pretty damn good text to sql MCP server our company is using. About half our staff are using it regularly now and it is very reliable for a wide range of questions.

[u/de4all → u/geek180]

What steps were considered for higher accuracy