feat: Derive the count of a limited dare.get request

[MrSwitch]

This ticket supersedes #31.

Obtain the number of rows a count request would have retrieved had it not been limited.

e.g.

// Request with a limit
const dataset = dare.get(request);

// How many rows matched to generate pagination
const count = dare.getCount(request);

Approach

Create a new function dare.getCount(request). This will be able to take an existing request object in the first parameter and retrieve the number of records which match this query.

This can be done by stripping away any fields, orderby, limit and start props.
Defining a single field containing COUNT(DISTINCT ${groupby}) where groupby is any custom or derived groupby applied to the matching dataset.

[MrSwitch]

🎉 This issue has been resolved in version 0.32.3 🎉

The release is available on:

• npm package (@latest dist-tag)
• GitHub release

Your semantic-release bot 📦🚀