Filter active users and reshape to {name, email, balance}
Run a jq filter against users.json that pipes the array through 'select(.active)' to keep only currently-active users, then reshapes each match into a smaller object with just name, email and balance. tryit.cfm pretty-prints the JSON-per-line output centrally.
Group users by country and aggregate counts/balances
Use 'group_by(.country)' to bucket users, then map each bucket to a summary object with the country name, head count, and total account balance. A compact example of using jq for ad-hoc aggregation without spinning up a database.
Convert users.json to CSV via @csv
Emit a CSV header row followed by one data row per user, using jq's @csv format string for proper quoting. The filter is loaded from a tiny .jq file via -f so the embedded double-quoted column names do not need to survive shell escaping. Add -r so the @csv output is raw text (not JSON-encoded strings).
# JQ - Help
Source: https://jqlang.org/
```
jq - commandline JSON processor [version 1.8.1]
Usage: jq [options] <jq filter> [file...]
jq [options] --args <jq filter> [strings...]
jq [options] --jsonargs <jq filter> [JSON_TEXTS...]
jq is a tool for processing JSON inputs, applying the given filter to
its JSON text inputs and producing the filter's results as JSON on
standard output.
The simplest filter is ., which copies jq's input to its output
unmodified except for formatting. For more advanced filters see
the jq(1) manpage ("man jq") and/or https://jqlang.org/.
Example:
$ echo '{"foo": 0}' | jq .
{
"foo": 0
}
Command options:
-n, --null-input use `null` as the single input value;
-R, --raw-input read each line as string instead of JSON;
-s, --slurp read all inputs into an array and use it as
the single input value;
-c, --compact-output compact instead of pretty-printed output;
-r, --raw-output output strings without escapes and quotes;
--raw-output0 implies -r and output NUL after each output;
-j, --join-output implies -r and output without newline after
each output;
-a, --ascii-output output strings by only ASCII characters
using escape sequences;
-S, --sort-keys sort keys of each object on output;
-C, --color-output colorize JSON output;
-M, --monochrome-output disable colored output;
--tab use tabs for indentation;
--indent n use n spaces for indentation (max 7 spaces);
--unbuffered flush output stream after each output;
--stream parse the input value in streaming fashion;
--stream-errors implies --stream and report parse error as
an array;
--seq parse input/output as application/json-seq;
-f, --from-file load the filter from a file;
-L, --library-path dir search modules from the directory;
--arg name value set $name to the string value;
--argjson name value set $name to the JSON value;
--slurpfile name file set $name to an array of JSON values read
from the file;
--rawfile name file set $name to string contents of file;
--args consume remaining arguments as positional
string values;
--jsonargs consume remaining arguments as positional
JSON values;
-e, --exit-status set exit status code based on the output;
-b, --binary open input/output streams in binary mode;
-V, --version show the version;
--build-configuration show jq's build configuration;
-h, --help show the help;
-- terminates argument processing;
Named arguments are also available as $ARGS.named[], while
positional arguments are available as $ARGS.positional[].
```
