I've recently toyed with server-side SQLite with LiteFS [1] to enable replication, and it has worked quite well for me. Are there any similar plans for distributed setups for DuckDB?
You can store your data as parquet file(s) and query these on separate nodes handling multiple queries. Or for the giant data create a split parquet datasets and speed up the queries.