Introducing Metrics SQL: A SQL-based semantic layer for humans and agents
Summary
Rill introduces Metrics SQL, a SQL-based semantic layer that defines metrics once and lets downstream tools, dashboards, and AI agents query them consistently. The post covers the concepts of measures and dimensions, how Metrics SQL compiles to OLAP SQL, and YAML-based metrics_view definitions, with examples and a path to using Claude via MCP. It also discusses limitations and future directions toward native database support for metrics semantics.