01 Durable business context
Does the system build a reusable understanding of your business, or does each answer start from the prompt?
It should ingest existing assets such as schema, prior SQL, dashboards, metric definitions, and team vocabulary. The result should be an inspectable context layer your team can improve.
02 Visible plan before execution
Can a business user and an analyst see what the system believes the question means before SQL runs?
Look for resolved terms, filters, time windows, joins, cohorts, calculations, and assumptions. A trustworthy AI analyst should show the plan, not just the answer.
03 Ambiguity handling
What happens when a term, metric, join path, or time period is unclear?
The system should ask, refine, or refuse instead of inventing a definition. This is usually the fastest way to separate a demo from a governable workflow.
04 Verified execution
Is SQL generated directly from language, or compiled from a checked analytical plan?
The same accepted plan should lead to the same SQL. Analysts should be able to inspect the plan and understand why the query is valid.
05 Compounding reuse
Does the accepted answer make the next related question easier, safer, or faster?
Validated definitions, segments, calculations, and plan patterns should persist. If everything disappears after the chat, the organization is not learning.
06 Operational ownership
Who helps the system land with business users and data teams in the first quarter?
Ask who owns onboarding, validation, feedback loops, and adoption. A good architecture still needs an operating motion.