Right, I saw no update in the SQL keyword list, and saw some (I guess old now) talk about Materialize where the speaker mentioned no updates, sorry!
Re:Introducing dbt + Materialize
by jldlaughlin on Monday March 01, 2021 @05:31PM
(#26309371)
No apologies necessary, we're an active work in progress! (And, hopefully, moving quickly!)
As per your second point, I have a less awkward way for you! Materialize supports a top-k idiom (https://materialize.com/docs/sql/idioms/#top-k-by-group) that is hopefully a bit more clear.