sequel_assoc_limit.rb

class Commit < Sequel::Model
end

class Repository < Sequel::Model
  one_to_many :recent_commits, :class => 'Commit',
    eager_limit_strategy: true,
    order: Sequel.desc(:id),
    limit: 3
end

# This will return all repositories with the last 3 commits loaded for each:
# Repository.eager(:recent_commits).all

# Queries generated on Postgres:
# SELECT * FROM "repositories"
# SELECT * FROM (
#   SELECT *,
#   row_number() OVER (PARTITION BY "commits"."repository_id" ORDER BY "id" DESC) AS "x_sequel_row_number_x"
#   FROM "commits" WHERE ("commits"."repository_id" IN (1))
# ) AS "t1" WHERE ("x_sequel_row_number_x" <= 3)