Snowflake’s ACCUMULATE: Build Custom Aggregates with Lambda Power

When SUM, AVG, and COUNT aren’t enough — here’s how to write the aggregate you actually need, without a single UDF.