That sounds like a rather serious application. Did you file an issue?
No, I tried Clickhouse instead, which worked without crashing or manual memory tuning.
Search the issues of the duckdb GitHub there’s at least 110 open and closed oom (out of memory) and maybe 400 to 500 that reference “memory”.
I filed many issues. They were aurtoclosed after 3 months of inactivity