Thijs

@cmdlineluser Could you also try these snippets and report your results?

@rustyconover I believe reading from `/dev/stdin` uses pipes, see `tools/shell/tests/test_read_from_stdin.py` for a test with this

I think we'd just appreciate context, regardless if this is reproducable or not, now we can't even reason about it

By the looks of it, the r-api tried to do a prepare, that prepare hit an exception ``` if (result->return_type.id() == LogicalTypeId::UNKNOWN) { throw ParameterNotResolvedException(); } ``` I assume that...

Though in the C-API we also don't put a try-catch around this: ```c++ duckdb_state duckdb_prepare_extracted_statement(duckdb_connection connection, duckdb_extracted_statements extracted_statements, idx_t index, duckdb_prepared_statement *out_prepared_statement) { Connection *conn = reinterpret_cast(connection); auto source_wrapper =...

In what way is the Python code streaming? We're just calling `.df` here, which materializes directly as a Pandas DataFrame, no?

Why are you comparing a streaming result set against a materialized one then? You can materialize in the C API as well A more equivalent test would be using: ```py...

It sounds like `autoinstall_known_extensions` is perhaps not set? Can you provide the output for `select * from duckdb_settings()`, I think that will be relevant here

Carlo is entirely correct

I'd argue that this needs a method to create a `duckdb_value` that's a DECIMAL, the appender can already append `duckdb_value` objects if I'm not mistaken