Query result limit applied to subqueries instead of main query

[rbarriuso]

Bug Report

Current behavior

The Limit of queries (100 by default) is applied to subqueries instead to main select in some cases. The Nestjs CRUD library builds the queries to group response with joined relations. Hence the default getMany() operation could return a incomplete set of data if any of the joined sub-queries had more than 100 results.

Expected behavior

All results that match the query should be returned.

Environment

@nestjsx/crud: 4.6.2
@nestjsx/crud-typeorm: 4.6.2
 
For Tooling issues:
- Node version: v18.18.2
- Platform:  Ubuntu Linux 22
- Database: postgres:12.5-alpine