era127

Currently, there is native functionality in duckdb sql for [Pivot](https://duckdb.org/docs/archive/0.9.1/sql/statements/pivot) as well.

The appender api should error as documented in [this issue](https://github.com/duckdb/duckdb-web/issues/2017) However it should not be much slower than SQLite, is it possible to share a mwe.

The default scope for TimeZone is [documented](https://duckdb.org/docs/configuration/overview) as being Global, which I assume in the R api would be for the Database type, while Local or Session would be for...

For example, if the day of month was 28 in NY but 29 in UTC then I'm not sure how to control that in the output. Instead if we use...

Yes, I apologize I got them confused. The other thing I wanted to suggest was to also have 'wday' as a numeric day of week rather than a character, which...

Would the code change be similar to the others and add a new function call to set $extras to NULL: ```r x

I think work around is to keep a reference 'owned' and then clone it to pass make new connections to pass to threads, as it is done in the r2d2...

In my experience with another client api, this was resolved by using the duckdb_query() c api function which will create a materialized result. When using the arrow api it will...

I think it would be helpful if the dplyr test was documented as a representation of the slider package, as opposed to using RcppRoll. The dplyr benchmark has been confusing...

I think adding a rolling or asof join, similar to this [asof benchmark test](https://bwlewis.github.io/duckdb_and_r/asof/asof.html), would be helpful for timeseries work. For duckdb, I believe the performance has significantly improved in...