Metrics SQL by Rill vs Windmill AI Workflow Builder

“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: LLM-assisted code generation scoped to Windmill's DAG node model, outputting actual runnable TypeScript or Python you can read, edit, and version-control. The DX bet is correct — they didn't try to hide the code behind an abstraction, they made the code the artifact. The moment of truth is whether the generated script is actually idiomatic and uses Windmill's resource types correctly, and from what I can see in their demos, it mostly does. This is not a weekend-script problem — Windmill's execution model, secrets handling, and scheduler are real infrastructure that would take weeks to replicate. The specific decision that earns a ship: generated code is inspectable and editable, not a black box.”

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

“Direct competitors are n8n's AI features and Temporal's developer workflows — Windmill beats both on the 'generated code you actually own' axis, which is a real differentiator. The scenario where this breaks is complex multi-service orchestrations with retry logic, conditional branching, and auth token refreshes — the generated nodes will be shallow and the user will spend more time debugging AI-hallucinated Windmill API calls than they would have writing the script manually. What kills this in 12 months is not a competitor but Claude or GPT-4o getting good enough at Windmill's own API that you just paste the docs and get the same result without needing the embedded builder. For now it ships because the underlying platform is genuinely solid and the AI feature adds real time compression for the first 80% of a workflow.”

“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 specific and falsifiable: workflow automation's bottleneck is script authorship, not orchestration, and LLMs will collapse that bottleneck faster than low-code drag-and-drop ever did. That thesis is already paying off — the trend is code-generating agents eating no-code tools from above, and Windmill is correctly positioned as the execution layer that survives that transition because it never pretended the code wasn't there. The second-order effect worth watching: if Windmill's AI builder gets good enough, it shifts workflow automation from a 'technical vs. non-technical' axis to a 'do you own your execution environment' axis — which is a power shift from SaaS vendors like Zapier to self-hosted infrastructure teams. Windmill is early on the 'AI-generated workflows running on owned infra' trend, and that's the right place to be when enterprise data-residency concerns start killing cloud-only automation vendors.”

“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 a devops or platform engineer at a mid-size company who needs internal automation and doesn't want to pay Zapier enterprise pricing — this budget comes from infrastructure or engineering tooling, not marketing, which means longer sales cycles but stickier contracts. The moat is the open-source distribution flywheel: self-hosters become cloud customers when they hit scale, and workflow definitions are deeply embedded in the product, creating real switching costs. The risk is that the AI Workflow Builder specifically has no moat — it's a prompt wrapper over the same models competitors use — but it doesn't need to be the moat, it just needs to accelerate time-to-first-workflow for new users, which it does. The business survives cheaper models because Windmill charges for execution infrastructure and seats, not tokens.”