collections/window_functions_utils library

Window functions (lag, lead, row_number) over ordered data — roadmap #471.

Functions

lag<T>(List<T> values, int index, int offset) → T?
Lag: value at index i - offset; null if out of range. Audited: 2026-06-12 11:26 EDT
lead<T>(List<T> values, int index, int offset) → T?
Lead: value at index i + offset; null if out of range. Audited: 2026-06-12 11:26 EDT
rank(List<num> values) List<int>
Rank: 1-based rank; equal values get same rank, next rank skips. Audited: 2026-06-12 11:26 EDT
rowNumber(int index) int
Row number (1-based index). Audited: 2026-06-12 11:26 EDT