🎆 Text-to-SQL6. Glossary

Chapter 6

Glossary

TermMeaning
Text-to-SQL (NL2SQL)Turning an English question into a database query
SchemaThe layout of the database: tables, columns and how they link. What the model sees instead of the data
Gold answerThe correct SQL for a test question, written and checked by a person
Execution accuracyMarking by running the SQL and comparing results, rather than comparing the SQL text
TokenThe unit models read and write, roughly ¾ of a word. Prices are per million tokens
Input / output tokensWhat you send (question + schema) / what the model writes back. Output usually costs 3–5× more
Cached inputInput the provider has seen recently, like our repeated schema. Charged at a fraction of the normal rate
Reasoning tokens“Thinking” a model writes before its answer. You pay for it even though you don’t see it
ServerlessPay per token on Fireworks’ shared hardware. The alternative is renting dedicated GPUs by the hour
HallucinationA confident answer with no basis, like the made-up profit margin
GuardrailA check outside the model, like opening the database read-only