Glossary · Core Concepts

SQL Generation

SQL generation is the automatic creation of SQL queries by software–typically an AI model–from a user's intent expressed in natural language.

SQL generation is what happens between your question and your answer in an AI database tool. The system takes your question plus knowledge of your schema (tables, columns, relationships) and writes the SELECT statement, joins, filters, and aggregations a data analyst would have written by hand. Good SQL generation produces queries that are not just syntactically valid but semantically correct–they answer the question you actually asked. This matters because a wrong-but-plausible query is worse than no query: it returns numbers that look real. That is why serious tools validate generated SQL against the live schema and let you inspect the query before trusting the result.

Fig — every answer ships with the tables, rows and SQL behind it.