I gave my text-to-SQL agent a business glossary. One version helped a lot, one did nothing.

A text-to-SQL agent sees table and column names. It does not know that "revenue" in your company...