Limit does not work properly with m2m

[imraan-go]

So here is the scenario, I want to select 2 items from each order on the following example: https://bun.uptrace.dev/guide/relations.html#many-to-many-relation

orders := []Order{}
db.NewSelect().Model(&orders).Relation("Items", func(q *bun.SelectQuery) *bun.SelectQuery {
		return q.Limit(2)
	}).Scan(ctx)

The following query only selects first 2 items instead of selecting 2 items per product.

[vmihailenco]

This is a limitation of the current m2m query generator. Perhaps we should check if limit != 0 and issue a separate query for each order.

[github-actions]

This issue has been automatically marked as stale because it has not had activity in the last 30 days. If there is no update within the next 7 days, this issue will be closed.