They didn't explain what "concurrent writers" is. But seems it's just serialized writes on server side.

I don't think that's correct. DuckDB already supports concurrent writes within one process. I don't see why this would suddenly serialize all writes.