{"repo":"sidequery/yardstick","free":true,"listed":false,"github":"https://github.com/sidequery/yardstick","clone":"git clone https://github.com/sidequery/yardstick.git","description":"An implementation of Measures in SQL as a DuckDB extension","language":"Rust","stars":58,"topics":["duckdb","duckdb-extension","metrics-layer","semantic-layer"],"license":null,"category":"databases-storage","readme_excerpt":"Yardstick A DuckDB extension implementing Julian Hyde's \"Measures in SQL\" paper (arXiv:2406.00251). What is this? Yardstick adds measure-aware SQL to DuckDB. Measures are aggregations that know how to re-aggregate themselves when the query context changes. This enables: - Percent of total calculations without CTEs or window functions - Year-over-year comparisons with simple syntax - Drill-down analytics that automatically adjust aggregation context How can I use this with any database? Sidemantic is a fully featured semantic layer from Sidequery that supports the yardstick syntax across many different databases. Even mix and match yardstick syntax with your existing semantic model definitions. Quick Start & Demo Notebooks Notebooks embed their dependencies via juv metadata. These notebooks load the local extension if it exists at: build/release/extension/yardstick/yardstick.duckdb extension and fall back to INSTALL yardstick FROM community . Syntax Defining Measures Yardstick automatically handles the grouping. All DuckDB aggregate functions are supported; non-decomposable aggregates (COUNT(DISTINCT), MEDIAN, PERCENTILE , QUANTILE , MODE) are recomputed from base rows at query time and support AT modifiers, but can be more expensive. Querying Measures On DuckDB 1.5+, queries containing AGGREGATE() are automatically intercepted by the extension's parser override, so no special prefix is needed. On older versions, the SEMANTIC prefix is still supported as a fallback. AT Modifie","default_branch":null,"files":null,"tree":[],"storefront":"/r/sidequery","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/sidequery/yardstick/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}