malloy-queries

What problem does it solve? Writing Malloy queries without a reference leads to common syntax errors like comparing timestamps to integers, misplacing chart annotations, or confusing where and having clauses. This Skill provides a grounded reference of query patterns, syntax rules, and error fixes so queries compile correctly the first time. ## Core Features & Use Cases - Query Pattern Library: Ready-to-use templates for aggregations, group-bys, time trends, filtered queries, percent-of-total calculations, and window functions with calculate. - Syntax Rules Reference: Covers date literals with @, truncation accessors, reserved keywords, regex string matching with ~, join path navigation via dot notation, and chart annotation placement. - Error Diagnosis Table: Maps common Malloy error messages like "Cannot compare a timestamp to a number" or "field is a bar chart, but is not a repeated record" to their likely causes and fixes. - Use Case: When a query fails with "no viable alternative at input 'month'", consult the error table to learn that month is a reserved word and rename the alias to order_month. ## Quick Start Ask the assistant to write a Malloy query showing monthly revenue as a line chart, and it will apply these patterns and rules to produce valid syntax.