Text-to-SQL, explained: how a question becomes a query, and where it goes wrong

Text to SQL, also called natural language to SQL, takes a question such as "How many orders did we ship last month?" and turns it into a query a database can run. A language model writes the SQL, but