Appender API Support

[mattgiles]

Documentation notes the Appender API is currently supported in C, C++, Go, Java, and Rust.

Are there plans to support via this Python package?

[evertlammerts]

Yes, I'm planning to add that in v1.6. Also very much open for contributions around this!

[amachanic]

I just came to request the ability to create a table (or at least a PyDataRelation) from Python using an iterable of dicts. Is that something you're targeting for the appender API enhancement, or should I create a separate issue?

[OutSquareCapital]

I just came to request the ability to create a table (or at least a PyDataRelation) from Python using an iterable of dicts. Is that something you're targeting for the appender API enhancement, or should I create a separate issue?

If that can be of some help, I implemented custom logic for various improved conversions from python objects here. They match what's expected from polars, as that can be seen in the tests

pql is not yet production ready, so feel free to copy paste the code and clean up what's not purely duckdb, and/or to raise an issue if you have any question.

[OutSquareCapital]

Yes, I'm planning to add that in v1.6. Also very much open for contributions around this!

Feel free to ping me for anything typing related! I would like to do the work for the stubs

[daviddallakyan2005]

v1.6 has not shipped and Python still has no Appender. Unless you are already implementing it yourself, I will take the scalar slice as a small PR: create, append, flush, and close, with tests. Chunks, nested types, and the query appender can wait as later PRs so this stays reviewable against the current queue. I will hold the PR if you would rather keep it.