i fail to understand how text2sql on quite simple data sources is anything to write home about 3 years after it came onto the market? can someone elaborate?

where it gets interesting is when you have a custom system that your LLM surely never saw (custom ERP) that has 50 sometime cryptic tables, unclear look up tables and unexplained flags.

something no text2sql solution solved for us.

we built a second mcp that lets the agent look up business logic (generated from source code) and then does better queries. that i think is something i never read in a blog post about a text2sql solution.

There is a missundertanding. This is not text2sql. This is CLI first; ideally the tool being operated by Claude Code and alike.

You could use claude code for the "text2sql" kind of part, but this is not why this tool exists. Nor what the article advocates.