Above is an impressionistic sketch from Gemini.
The idea is we want to be able to de-duplicate records that share a column value in a view, while keeping the first n according to some ordering. Ideally for each deduplication, you should be able to specify, the target column to depuplicate on, n, and the ordering (which has the same params as a sort).
This is easy to implement, and will unlock a lot of value for us by preventing us from having to create explicit “Most recent result” columns and manually relabel existing results, if we want a view of our most recent results for each serial number.
