How about writing with sqlite and querying with duckdb-sqlite, using a replica or WAL, to avoid locks?