limit method
Sets the LIMIT and optional OFFSET for the query.
limit The maximum number of rows to return.
offset Optional offset for pagination.
Returns this to enable method chaining.
Example:
query.limit(10); // LIMIT 10
query.limit(10, 20); // LIMIT 10 OFFSET 20
Implementation
Sqler limit(int limit, [int? offset]) {
_limit.limit = limit;
_limit.offset = offset;
return this;
}