limit method
Limits the amount of rows returned by capping them at limit. If offset
is provided as well, the first offset rows will be skipped and not
included in the result.
Implementation
Self limit(int limit, {int? offset}) {
limitClause = Limit(limit, offset);
return _asSelf();
}