Sequel recently added support that allows use of the ROW_NUMBER window function to correctly eagerly load associations that limit the number of returned records.
