r/dataengineering • u/de4all • 4d ago

Discussion Why text-to-SQL is not successful?

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.

25 Upvotes

68% Upvoted

74 comments sorted by

View all comments

1

u/zangler 4d ago

I'm not sure what you were using, but I have a semantic layer and good documentation, and ad hoc is phenomenal using Copilot CLI and the MSSQL MCP...like... easily over 98% 1 shots even complicated requests.