3 ms·

Reminder you can also get DuckDB to slurp the JSON natively and give you a much more expressive query model than anything jq-like.

• maleldil 7mo ago
  How does it deal with nested objects? E.g. one of the fields/columns is an array of objects.
  • quotemstr 7mo ago
    Beautifully. UNNEST works well, as do the pivot operators.