Feature Request: Appender

[davisylvestre]

Why do you want this feature?

It allows for the bulk insertion of a generator without necessarily going through the dataframe.
I was unable to locate an alternative method in the documentation, if there is one.

[paultiq]

I implemented an experimental python binding to the DuckDB C Appender API here: https://pypi.org/project/bareduckdb/

Note: this is just an experiment/proof of concept... this could be ported to DuckDB-Python fairly easily.