Enhancement: Need Support for ROW_NUMBER() with PARTITION BY and ORDER BY

Need support to have ROW_NUMBER() column with PARTITION BY and ORDER BY clause to be used along with $filter to retrieve specific entities based on the rank no. e.g. for the below schema you might be interested to retrieve the details of products having max price in each category.
Product {
Id: Number,
Name: String,
Category: String,
Price: Number
}

The URL can be something like:
https://<host>/odata...?$compute=rowNumber($select=Category;$orderby=Price desc) as row&$select=Id,Name,Category,Price&$filter=row eq 1

The issue names no files, tests, or entry points. Start by locating the query handling for $compute, $filter, and rowNumber in this repository, then verify the example URL returns the highest-priced product per category. Done means supporting PARTITION BY and ORDER BY together with filtering on the computed rank.