Thanks for repeating yourself; this comment potentially influences my decision-making about DuckDB. Good to know about the negatives too.

At what data volumes does it start erroring out? Are these volumes larger than RAM? Is there a minimal example to reproduce it? Is this ticket related to your issue? https://github.com/duckdb/duckdb/issues/12480