You can just import your CSV file to SQLite without any limits, e.g.:
sqlite3 :memory: -cmd '.import -csv file.csv table'\
'SELECT col, COUNT(*), AVG(total) FROM table GROUP BY col'
More: https://www.sqlitetutorial.net/sqlite-import-csv/