Semantic Layer — Business Context for NL2SQL

To fix incorrect NL2SQL outputs, you need a semantic layer that injects business-domain context. This Skill provides a KPI glossary with exact SQL computations, preventing the model from inferring calculation logic from unrelated database schema fields.

Your NL2SQL pipeline misinterprets business terms because raw database schemas lack domain semantics. Applying a semantic layer with a synonym dictionary and value profiles maps categorical enum values to the correct tables and columns for accurate query generation.

The best way to translate Vietnamese business language into SQL is by using a semantic layer synonym dictionary. It maps domain terminology directly to the correct database tables and columns, ensuring the NL2SQL model queries the right entities.

You can onboard a new database by following a repeatable checklist to update synonyms, value profiles, and the KPI glossary. This operational workflow ensures new tables and business terminology are correctly mapped before generating SQL.

Yes, you can enforce WHERE and GROUP BY logic by providing few-shot example patterns. This Skill supplies representative Question to SQL patterns so the generated queries follow your specific project conventions and domain calculation rules.

You need a business glossary to calculate domain metrics like Doanh thu thuần accurately. The glossary defines these KPIs with the exact SQL computation the model must use, overriding any incorrect logic inferred from the raw schema.