Consistency vs raw SQL
Raw SQL is precise, but two people can write very different queries for the same business question. STYD aims to make business questions more repeatable.
The trade-off
Raw SQL
Exact and powerful, but technical, and easy to vary between people, so results can drift.
Exact and powerful, but technical, and easy to vary between people, so results can drift.
STYD
Asks in business language and leans on shared metadata and approved knowledge for a consistent interpretation.
Asks in business language and leans on shared metadata and approved knowledge for a consistent interpretation.
How consistency improves
The more you review AI Guide (table and column meaning) and capture definitions in Brief your assistant, the more consistently STYD interprets the same terms, so a question asked by different people tends to mean the same thing.
Still validate
Consistency is a goal, not a guarantee. For important outputs, review the logic behind the answer and confirm the figures before relying on them.