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