Metrics SQL by Rill vs Modo

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.

Modo is an open-source AI IDE built on the Void editor (a VS Code fork) that flips the script on how AI coding tools work. Instead of jumping straight to code generation, Modo forces a spec-first workflow: describe what you want, and the agent converts your prompt into structured requirements docs, design docs, and task breakdowns stored in a persistent `.modo/specs/` directory before writing a single line of code. The approach draws from the "vibe coding is bad actually" school of thought. Modo's steering files and agent hooks let developers set coding conventions, stack preferences, and project constraints that persist across sessions. Autopilot mode chains spec generation through implementation, while parallel chat lets you run multiple agent conversations simultaneously against the same codebase. Built by a solo developer and posted to Hacker News as a Show HN, Modo positions itself against Cursor, Windsurf, and Kiro. The bet: slowing down agents with structured planning up front produces fewer hallucinated architectures and rewrites. It's early — rough edges abound — but the spec-driven philosophy is increasingly mainstream as larger teams adopt AI coding tools.