Metrics SQL by Rill vs Terrarium

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.

Terrarium is a multi-turn evaluation and optimization engine for LLM agents built by evolvent-ai. Unlike static benchmark suites that measure agents against fixed input-output pairs, Terrarium creates persistent, stateful "living environments" — simulated deployment contexts where agents operate over extended sessions, accumulate state, use tools, and interact with simulated external systems. You evaluate agents the way you'd test a car: by driving it, not by measuring its doors. The system supports configurable environment complexity, including simulated databases, APIs, file systems, and user personas. Agents are scored not just on final outputs but on trajectory quality — how efficiently they reached the answer, how often they hallucinated intermediate steps, and how well they recovered from dead ends. The engine also supports continuous optimization loops where poor-performing trajectories trigger automatic prompt refinement. With 17 stars and created April 14, Terrarium is extremely new. But it's addressing a genuine gap: the disconnect between how agents perform on static benchmarks versus how they behave in production. As enterprise AI deployments scale, the need for realistic pre-production evaluation is becoming critical.