Metrics SQL by Rill vs Modal Labs Sandboxed Code Execution API

“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 clean: ephemeral container spawn, code in, result out, billed by the second. The DX bet Modal made is that developers shouldn't have to think about container lifecycle, networking, or cleanup — and they're right. The moment of truth is `modal.Sandbox.create()`, and it survives: secrets inject cleanly, resource limits are set at call time, not in a config file, and the sandbox tears down automatically. You could replicate this with Firecracker microVMs, some Lambda plumbing, and a weekend — but you'd also spend the next month debugging cold starts and network egress. The specific decision that earns the ship: resource limits are first-class parameters in the API call, not an afterthought in a YAML manifest somewhere.”

“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 competitor is E2B, which has been doing sandboxed code execution for agents longer and has a larger community. Modal wins on infrastructure maturity — their container cold start story is genuinely better than most, and the secret injection model is cleaner than E2B's current approach. Where this breaks: long-running agent workflows that need persistent filesystem state across multiple sandbox calls will hit friction fast, because Modal's ephemerality is a feature until it isn't. What kills this in 12 months isn't a competitor — it's that OpenAI and Anthropic both ship native code execution environments inside their agent frameworks, commoditizing the standalone sandbox market. Modal survives only if they've built enough workflow lock-in through the broader platform before that happens.”

“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 here is falsifiable: within 2 years, most AI agents will need to execute code as a core capability, and the teams building those agents won't want to own execution infrastructure. That bet is on-time, not early — the agentic coding wave is already visible in Devin, Claude's computer use, and every copilot that runs tests. The second-order effect that matters isn't faster code execution — it's that safe sandboxing lowers the activation energy for agents to attempt side-effectful actions, which expands what agents can be trusted to do autonomously. The dependency that has to hold: agent frameworks must stay polyglot and API-driven rather than consolidating into vertically integrated stacks that bundle their own execution. If LangChain or the next dominant framework ships a native sandbox, Modal needs the broader platform relationship to matter more than this single API.”

“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 is a developer or ML engineer at a company building an AI agent product, pulling from an infra or tooling budget — this is a real buyer with a real check. The pricing architecture is Modal's standard compute billing, which scales with usage and aligns cost with value delivered, though it can surprise teams at scale who don't instrument their sandbox call frequency. The moat concern is real: this is one API surface on top of Modal's broader platform, and the defensibility comes from Modal's overall container infrastructure quality and the stickiness of platform-level billing consolidation, not from the sandbox feature alone. The business survives model commoditization because Modal is selling compute, not intelligence — when models get cheaper, agents run more sandboxes, not fewer.”