Azure AI Foundry Model Routing vs Metrics SQL by Rill

“The primitive is a complexity classifier that sits in front of your model pool and makes the cheap-vs-expensive call so you don't have to — genuinely useful infra that I've hacked together manually more than once. The DX bet is endpoint-compatibility: one URL swap, existing SDK calls, no schema changes, which is exactly right. The moment of truth is registering your model pool and watching the first routing decision happen transparently; if the observability surface shows which model each request hit and why, this earns its keep immediately. The specific decision that earns the ship: making this a passthrough layer with no new SDK dependency rather than another SDK you have to adopt.”

“We've been burned by data agents that invent their own GROUP BY logic and produce wrong numbers that look right. Metrics SQL solves this at the infrastructure level — define revenue once, have every agent query the same definition. The SQL-native interface means no new tools for agents to learn; they just use the tables.”

“Direct competitor is LiteLLM's router plus any prompt complexity classifier you wire up yourself — the open-source path exists and is well-documented. Where this breaks: latency-sensitive applications where the classification overhead exceeds the cost savings, and high-stakes tasks where the router confidently misclassifies a complex reasoning prompt as 'simple' and hands it to a small model. The 40–60% cost reduction claim comes from Microsoft's own early adopter data, which is not an independent benchmark and should be treated accordingly. What kills it in 12 months: OpenAI or Anthropic ships native tier-routing at the API level, eliminating the need for an intermediate dispatch layer — this tool's entire thesis evaporates if model providers internalize the abstraction.”

“The value here is only as good as how well-maintained your metric definitions are — if analysts don't keep them updated, agents query stale or wrong definitions and you've added a layer of false confidence. Adopting a semantic layer also creates vendor dependency; migrating away from Rill's cloud later is a real switching cost. For smaller teams without dedicated data engineering, maintaining a semantic layer is overhead.”

“The buyer is any Azure-committed enterprise already running inference at scale — this comes out of the existing AI/ML budget and requires zero new procurement, which is the cleanest possible GTM. The moat is distribution: Microsoft doesn't need defensibility because it owns the infrastructure layer underneath, and a company already paying Azure egress costs isn't going to route through a third-party classifier. The stress test that matters isn't model price collapse — it's whether Azure keeps model prices high enough that routing arbitrage stays meaningful; if GPT-5-mini costs a rounding error, the whole value prop shrinks to quality tiering alone. Still a ship because 'save 50% on your biggest cloud line item with one config change' is a self-approving budget decision.”

“The thesis is: prompt complexity is classifiable at inference time with enough accuracy to arbitrage meaningfully across a heterogeneous model pool, and that arbitrage window persists long enough to justify building infrastructure around it. This bet requires two things to stay true — model capability gaps don't collapse (a fast-improving frontier might make routing moot) and inference costs remain differentiated across tiers (plausible for 2–3 more years given compute economics). The second-order effect that's underappreciated: if this works at scale, it normalizes the idea of the model pool as infrastructure rather than product choice, which shifts power from model providers to orchestration layers — Azure included. The tool is on-time to the model-routing trend, not early, but being the platform that makes it boring-and-reliable is a legitimate strategic position.”

“Data governance and AI agents are on a collision course. As more business decisions are delegated to AI, the correctness of KPI computation becomes load-bearing — a hallucinated revenue figure that influences a product decision is a serious failure mode. Metrics SQL represents a class of infrastructure that will become mandatory as AI takes on more analytical work.”

“I rely on AI to pull weekly performance data, and the number of times it's given me different 'correct' answers for the same metric is maddening. Having a single governed source that every AI query resolves against means I can trust the numbers I'm making decisions on. That trust is worth a lot.”