embedded-database

In Big Query there is a function array_concat_agg that aggregates array fields by concatenating the arrays. In Snowflake there is a flatten function that can unnest nested arrays into single array. I am looking for similar functionality in duckdb.

select flatten([[1, 2], [2, 3], [4, 5]] would return [1, 2, 2, 3, 4, 5]
I would also need a distinct option:
`select flatten(DISTINCT [[1, 2],

Right now, to get an acceptable experience in dtlv, one has to use rlwrap, i.e. launch it like this rlwrap dtlv. It would be nice to integrate with jline3 library to have a better experience natively.

After risinglightdb/risinglight#464 refactor has been completed, we can remove some prior optimizations in storage crate!

https://github.com/risinglightdb/risinglight/blob/5708a8e2f1d72dd5e7db3c3fb5b93f5c59c348e6/src/storage/chunk.rs#L18-L27

Now ArrayImpl has an Arc inside, so we can safely change the Arc<ArrayImpl> to ArrayImpl in storage chunk with cheap c