semantic layer

A query that errors is a bug. A query that runs and returns a plausible wrong number is a product teaching a finance team, one figure at a time, not to trust it. The diagnosis is a classification exercise, and the fix is almost never a better prompt.

Two correct queries, two different numbers, one word. The fix is two certified definitions with different names, a bridge that closes to the dollar, and a rule for what the agent does with the bare word. The tempting join returns $9.0M.

A tool can draft a glossary for 1,800 tables in an afternoon. It cannot decide which revenue finance means. The design is about where approval lives, how the query path enforces it, and how you prove the agent is ready one question class at a time.