Paginator for the :many context?

[basilex]

Hi, All!
Is there a solution to paginate :many context?
Thanx a lot!

[videate-karim]

In my reading of the docs, you would do:

-- name: GetThings :many
SELECT * FROM things
 WHERE field = $1
 ORDER BY created_at desc
 LIMIT $2 OFFSET $3;

The generated function looks like this:

type GetThingsParams struct {
	Field string
	Limit    int32
	Offset   int32
}

type GetThingsRow struct {
	ID          int32
	Field      string
       ...
}
func (q *Queries) GetThings(ctx context.Context, arg GetThingsParams) ([]GetThingRow, error) {
   ...
}