Snowflake, BigQuery, and DuckDB have the QUALIFY keyword. As an analytics engineer I use it primarily to deduplicate data, like so: Select user_id, amount, updated_at from table qualify row_number() over (partition by user_id order by updated_at desc) = 1 This query deduplicates the ...