Ok so you have multiple writers in write-only mode and then you switch to read-mode if you need to read? How would that work e.g in an IoT ingest system with lots of telemetry coming in.
SQLite does a great job to support single writer and multiple readers. That's what we use for aggregation right now. DuckDB is purely post analytics.