DuckDB is faster than SQLite on an analytical type of query. That's expected because DuckDB is column-based and designed exactly for this type of queries.
The analysis would be more telling if it measured insert performance as well.
The analysis would be more telling if it measured insert performance as well.
Columnar databases are a good fit here.
Mature users need to evaluate how their workloads match the benchmarks, it isn't a matter of DuckDB or SQLite "winning".