This is a list of cases how AlaSQL can manipulate JavaScript data (JSON).
Counting:
- How to add own keys for grouped output?
- How to aggregate an array of objects based on object property?
- How to create a cleaned up contact object of an array of contact data?
- How to count matching values in array?
- How to count the number of times each value in the array appears in that array?
- How to count total with two criteria?
- How to extend and merge two arrays containing objects?
- How to intersect arrays of objects based on object property value?
- How to joins and aggregates in Javascript arrays?
- How to filter an array using an array?
- How to find a item based on a key?
- How to find and count unique values in nested JSON objects?
Grouping:
- How to group?
- How to group by array of objects?
- How to group and count?
- How to Group By and Sum?
- How to group arrays by multiple fields?
- How to group javascript object grouped by multiple attributes?
- How to group and sort a JS array?
- How to match the sub property in an objects array?
- How to merge object arrays based on join of a key property in each?
- How to group complex JSON object by nested properties?
- How to SUM and GROUP BY of JSON data?
- How to unique by multiple properties?
- How to use aggregate functions using node-js?
- How to use SQL to query javascript objects?
Other: