Support aggregation methods

[KutsenkoA]

I'm submitting a ...

[ ] Regression (behavior that used to work and stopped working in a new release)
[ ] Bug report
[x] Feature request
[ ] Documentation issue or request

Aggregation functions

It would be awesome if SDK had next aggregation functions implemented:

• count
• min
• max
• avg
• sum
• every

Possible syntaxes

There are a few ways to implement this functionality.

1. Simple string

Simplest syntax where aggregators are provided as the strings. Example:

dataset("users")
  .select()
  .fields("max(age)", "isadmin")
  .execute()

Despite the fact that it's an easy to develop and clear solution, it has certain difficulties:

• no type checking not only for aggregation functions, but alslo this syntax removes field name checking for the fields() method in Typescript.
• no hints what functions are allowed
• difficult to extend (for example with aliases)

2. Imported statement

Example:

import aggregation from "jexia-sdk-js";

dataset("users")
  .select()
  .fields(aggregation.max("age"), "isadmin")
  .execute()

This solution looks a little better than previous, but customer has to import additional object. Also it's impossible to add field name checking to aggregation.fn()

3. Object

Example:

dataset("users")
  .select()
  .fields({ fn: "MAX", field: "age" }, "isadmin")
  .execute()

Probably, best solution. Has type checking, hints for function names, easy to extend with additional properties.

[miss-tique]

🎉 This issue has been resolved in version 3.5.0 🎉

The release is available on:

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

Your semantic-release bot 📦🚀