New array data type in version 0.10.0 can't be returned to R

[BorgeJorge]

con <- dbConnect(duckdb())
dbGetQuery(con, "select array_value(1,2,3)")
#> Error: rapi_prepare: Unknown column type for prepare: INTEGER[3]

[krlmlr]

Indeed. I had to remove those values from tests_all_types() in 19c9533.

[DavZim]

Hi all,
is there something that I can do about this?
We oftentimes use DuckDB as a vector store for Embeddings, and as the name suggests, this involves vectors/arrays.
At the moment we construct the query and insert the values into the query, which is not optimal.
Thanks