For example, lets say you have an association from Position to employees, where you want to return only the first employee for each position, ordered by employee name.
This is very similar to the previous case, and Sequel supports window functions to correctly eagerly load it as well.
Sequel also supports using PostgreSQL's DISTINCT ON to eagerly load it, which often performs better.