For example, if you want your employees association for Position to only return the first 10 matching employees, all ruby ORMs handle that fine in the general case, but other ruby ORMs won't eagerly load such associations correctly, instead returning all associated objects instead of just the first 10.
Sequel supports an option that applies a window function that is partitioned by the related key columns to correctly eagerly load such associations.