Love this. Always interesting to see novel ways of querying data in the terminal, and I agree that jq’s syntax is difficult to remember.
I actually prefer nu(shell) for this though. On the lobste.rs thread for this blog, a user shared this:
| get license.key -i
| uniq --count
| rename license
This outputs the following:
╭───┬──────────────┬───────╮
│ # │ license │ count │
├───┼──────────────┼───────┤
│ 0 │ bsd-3-clause │ 23 │
│ 1 │ apache-2.0 │ 5 │
│ 2 │ │ 2 │
╰───┴──────────────┴───────╯
I really like Nushell. I would not run it as a daily driver currently, as it mostly doesn’t win me over from Fish, feature-wise, but I love having it available for anything CLI date pipeline work I need to do.