This conference talk from Data Council features Mike Driscoll, Co-Founder & CEO of Rill Data, sharing insights from building Rill's SQL-based metrics layer using DuckDB. Explore how to aggregate raw data into summarized metrics and enable dimensional slicing through declarative SQL expressions. Gain valuable perspectives on implementing fast OLAP engines for real-time data access with sub-second response times, essential for analytics teams seeking to define metrics using familiar SQL dialect as part of a BI-as-code philosophy. The 26-minute presentation is part of the Analytics & BI track from Day 2 of the 2025 Data Council event.