take method
Limits each parent's result to count rows; negative counts are rejected.
Batched per-parent pagination requires explicit orderBy.
Implementation
Relation<R, F> take(int count) {
if (count < 0) throw ArgumentError.value(count, 'count');
return copyQuery(queryState.copy(limit: count));
}