If you're writing out data for analytical read only use - go with DuckDb all the way, over SQLite.

Thanks, I will look into it!