Context Navigation

Changes between Version 1 and Version 2 of Ticket #35396, comment 1

-              v1
+              v2
 Changing the behavior would trivial, adjust `Where.split_having_qualify` to always return everything in `qualify_node` when it's present and nothing in `where_node` or `having_node` but I don't think it's the right thing to do.
+Changing the behavior would be trivial, adjust `Where.split_having_qualify` to always return everything in `qualify_node` when it's present and nothing in `where_node` or `having_node` but I don't think it's the right thing to do.
 The real problem here is the ambiguity of what should be done when users filter against non-windowed and windowed expressions at the same time.
 …
   `col1` = (`first`) AND `first_active` = True
 }}}
+It's a common pattern when you're interested in multiple values over the same window and why there's even a way to define window aliases that can be references by multiple window expressions.