[chrisjc]

Sounds like a job for DuckDB. DuckDB is to Snowflake/Bigquery (OLAP/analytics) what sqlite is to mysql/postgres (OLTP).

https://sql.quacking.cloud/ https://duckdb.org/docs/archive/0.9.2/api/wasm/overview