Metrics SQL by Rill vs ml-intern

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.

ml-intern is an open-source autonomous ML engineering agent from HuggingFace that can read research papers, design experiments, write and run training code, evaluate results, and push trained models to the HuggingFace Hub — all without human handholding. It runs a closed agentic loop for up to 300 iterations, integrating natively with HF Datasets, Inference Endpoints, and documentation. The system includes a doom-loop detector to prevent infinite debugging spirals, session upload to HF for persistent multi-day runs, and supports both zero-shot paper-to-model tasks and structured experiment pipelines. It's specifically designed to run on HuggingFace's own compute infrastructure, which gives it native access to GPU clusters that most comparable agents have to provision externally. The project targets ML researchers and small teams who want to explore a paper's ideas without doing the full implementation grind themselves. The HuggingFace ecosystem integration is the key differentiator — this isn't a generic code agent that happens to write PyTorch; it's purpose-built for the HF workflow, complete with automatic model cards and benchmark uploads.