Is Text-to-SQL ready for domain-specific applications, like e-commerce or SaaS?

I think it depends on the dataset complexity. For pre-curated datasets, it’s a straightforward implementation. For more complex or domain-specific applications, adding tools like RAG and LangChain ensures that the system understands unique relationships and context, delivering highly accurate results. For example, in e-commerce, you can ask, "Which products had the highest return rates last quarter?", and get precise insights, even from large, unstructured datasets. What are your thoughts? Here is a great article about this technology. Highly recommend checking if you want to know more: https://jetsoftpro.com/blog/text-to-sql-how-this-trending-technology-works/