If your work is more OLAP focused, DuckDb has good tools for loading csv files. https://duckdb.org/docs/data/csv

DuckDB is like a columnar SQLite. It also has great support for Pandas DataFrames.