feat: add getResultAndCount

[rubiin]

Is your feature request related to a problem? Please describe.
On typeorm we can use a function called getManyAndCount which can be used on querybuilder
that executes SQL query and returns entities and overall entities count (without limitation)

Describe the solution you'd like
Add a function getResultAndCount which returns the count and the entities as well
Example:

const [result, total] = await qb
			.take(limit)
			.skip(offset)
			.getManyAndCount();

Describe alternatives you've considered
For now we can do,

const result = await qb.getResult()
const total = await qb.clone().count("id", true).execute("get")

Additional context
The typeorm implementation can be found here
https://github.com/typeorm/typeorm/blob/15a4eb942e2d794eb5975e7a9e8b16cfe478a026/src/query-builder/SelectQueryBuilder.ts#L1832

[erie0210]

Can I try this one ? 🙌

[B4nan]

Sure!