Metrics SQL by Rill vs Azure AI Foundry SDK v2.0

“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.”

“The primitive here is a declarative runtime that resolves agent graphs at execution time — YAML drives the wiring, the SDK handles the state machine. The DX bet is that configuration-as-code beats imperative orchestration for multi-model pipelines, and for teams already living in ARM templates and Bicep, that bet is correct. The OpenTelemetry integration is the actually important detail nobody is emphasizing enough: getting trace context threaded through agent hops without custom middleware is a real problem this solves. My concern is the classic Azure problem — the first 10 minutes will involve az login, resource group provisioning, and at least two managed identity configs before you run a single inference call. The weekend-script alternative exists for two-agent workflows; this earns its keep only when you're wiring four or more heterogeneous models with shared memory state.”

“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 direct competitors are LangGraph and AWS Bedrock Agents, and Azure is shipping a credible third option here — not a winner, but not a toy either. The specific scenario where this breaks is cross-cloud or hybrid deployments: the YAML config is meaningfully Azure-specific, so the moment a team needs a non-Azure model endpoint or an on-prem memory store, the abstraction leaks badly. The 12-month kill vector is not a competitor — it's Microsoft itself, which has a documented history of shipping overlapping agent frameworks (Semantic Kernel is still a thing) and letting teams guess which one is canonical. What would tip this to a strong ship: a clear statement that this supersedes Semantic Kernel for new projects and a migration path that doesn't require rewriting the config layer.”

“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.”

“The thesis embedded in this release is that agent orchestration will be infrastructure, not application logic — that the same way you don't write your own load balancer, you won't write your own agent router in two years. That's a plausible and specific bet, and the OpenTelemetry alignment is the tell that Microsoft is positioning this as a platform layer, not a product layer. The second-order effect if this wins: observability vendors (Datadog, Honeycomb) gain leverage over enterprise AI deployments because tracing becomes the audit surface that compliance teams require, and whoever owns the trace schema owns the compliance narrative. The risk is the trend line: declarative orchestration is right on time, but Microsoft is riding it into an ecosystem that already has momentum behind Python-native tools, and YAML-first config is a cultural mismatch for the ML engineers who actually build these pipelines.”

“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.”

“The buyer here is an enterprise Azure architect, and the check comes from the cloud infrastructure budget — that part is clear. The problem is the moat question: this SDK is free, the differentiation is Azure service integration, and the actual revenue mechanism is Azure compute consumption. Microsoft's margin on this is real, but for any independent team building on top of this SDK, there is zero defensible position — you are a configuration layer on top of a vendor's orchestration layer on top of a vendor's model endpoints. Every abstraction you build is one Azure product update away from being native functionality. I'd ship this if you're an Azure-committed enterprise team standardizing internal tooling; I'd never build a product business on top of it.”