chDB

chDB

This is a really interesting development: chDB offers "an embedded SQL OLAP Engine" as a Python package, which you can install using "pip install chdb". What you're actually getting is a wrapper around ClickHouse - it's almost like ClickHouse has been repackaged into an embedded database similar to SQLite.

Via The birth of chDB

clickhouse database development embedded install olap package pip python sql sqlite wrapper