Streaming SQL Window Functions: Tumbling, Hopping, Session, and Cumulative

TL;DR: Streaming SQL gives you four window patterns: tumbling for fixed non-overlapping buckets, hopping for sliding overlapping ones, session for activity-bounded groups, and cumulative running total