Libretto vs Metrics SQL by Rill

Libretto is an open-source TypeScript toolkit for building and maintaining browser automations that are actually reliable. Unlike most AI-driven browser tools that use probabilistic reasoning to select elements at runtime, Libretto works by having the AI generate deterministic selectors and action sequences upfront — then executing them with zero LLM involvement at runtime. The AI is your authoring tool, not your runtime dependency. The core insight: most AI browser automations fail in production because they call an LLM on every page interaction. Libretto flips this by using AI to write and update the automation scripts, but running them as ordinary code. When a site changes and your automation breaks, Libretto detects the failure and prompts you to let AI update the selector — then it's deterministic again. Built by the team at Saffron Health, the library hit HN's front page today and is generating discussion as a more pragmatic alternative to fully autonomous browser agents. For anyone who's tried Playwright with AI wrappers and found them unreliable in CI/CD, this is the architecture that's been missing.

Metrics SQL is a SQL-based semantic layer from Rill Data that solves a specific and painful problem: AI agents that query your data warehouse tend to hallucinate aggregation logic, producing metrics that look plausible but are mathematically wrong. Metrics SQL lets analysts define business metrics once — revenue, MAU, conversion rate, ROAS — in a governed definition layer, and then exposes those definitions as queryable SQL tables. Every dashboard, notebook, and AI agent resolves from the same source. The technical approach is elegant: rather than inventing a new DSL, Metrics SQL extends SQL itself. An agent that knows SQL can query `SELECT * FROM metrics.weekly_revenue` and get correctly computed numbers without needing to know how revenue is defined, which tables it joins, or how edge cases like refunds are handled. The semantic layer intercepts the query, applies the governed definition, and returns correct results. The implications for AI-native data stacks are significant. Currently, one of the biggest failure modes for AI analysts and BI agents is inconsistent metric computation — different agents or dashboards produce different numbers for 'revenue' because they implement aggregation logic differently. Metrics SQL addresses this at the infrastructure level, not by improving agent prompting.