Hi, does daft json unnset support in SQL queries? ...
# general
v
Hi, does daft json unnset support in SQL queries? Is there any grammar like DuckDB struct explode? Something similar to the following SQL would be nice
Copy code
df = daft.from_pydict({
    "json": [
        '{"a": 1, "b": 2}',
        '{"a": 3, "b": 4}',
    ],
})
df = daft.sql("SELECT json.* FROM df")
df.collect()
r
You can do unnest(x) or x[“*”]
v
Yeah, but is there any SQL form query support this?
r
You should be able to use unnest in SQL
v
Seems it doesn't work. I wonder if daft currently supports this