Phillip Cloud

One question is whether this should be included in all aggregates, including `Sum`, `Mean` etc.

This will need to wait until [pyarrow 9.0.0 support](https://github.com/ibis-project/ibis/pull/4315) is merged here which in turn depends on https://github.com/NixOS/nixpkgs/pull/185124. This PR will be continually updated and in theory should eventually be...

FWIW, Presto has a `JSON` type stored as a string. The main purpose it serves is to indicate that the underlying string is valid JSON. For example, ``` sql select...

Additionally Presto uses a subset of [JSONPath](http://goessner.net/articles/JsonPath/) to let users pick out parts of the JSON blob that they want. An ibis-worthy API might look something like this: ``` python...

We could also leverage [jsonpath-rw](https://github.com/kennknowles/python-jsonpath-rw) which is a Python DSL that generates JSONPath expressions.

Should we limit the scope here? E.g., arbitrary JSON is out of scope, but JSON with a well-defined, uniform schema per record (including arbitrary nesting) is in scope. The [Apache...

For the record it looks like each of the systems mentioned by @wesm have three different ways of unnesting for arrays (similar for maps): Given a table `t`: ``` sql...

BigQuery: ``` sql SELECT element FROM t.elements ``` or ``` sql SELECT element FROM UNNEST (t.elements) ``` The `UNNEST` is optional according to [the docs](https://cloud.google.com/bigquery/sql-reference/query-syntax#unnest)

I'll make a new issue for the array API. I've started work on it by way of getting the type system in place and also added an "array_agg" function (called...

We have JSON and JSONB types now, and with 3e2efb433 we have a minimal API for extracting object values or array elements. The remaining work is implement feature requests for...