“It’s a LOT slower than using sqlite3 directly though.”
That line is Willison on his own sqlite-utils tool. One sqlite3 command opens an in-memory database, imports a CSV and runs a GROUP BY across millions of taxi rides. No server, no Pandas, no install beyond a binary that is already on most machines. Half the data tools sold to analysts are a worse version of this.