Is there a database file format that supports columnar storage query able via SQL? For OLAP style queries. I've tried SQLite for this usecase but the query fal

Is there a database file format that supports columnar storage query able via SQL? For OLAP style queries. I've tried SQLite for this usecase but the query falls down when querying millions of rows. I know there is parquet file format but I'm wondering if there is like a SQL engine that can sit on top of something like that similar to SQLite