You can perform sql queries with many of the DB clients available, such as Heidi, or Deaver, and also through python. Sqlite is OLTP though, for analytical pur

You can perform sql queries with many of the DB clients available, such as Heidi, or Deaver, and also through python. Sqlite is OLTP though, for analytical purposes I'd use an OLAP DB like DuckDB. IMO dumping workload in DB is nice, specially when your dataset doesn't fit in RAM.