DuckDB is really neat, recently added PDO interface for it for PHP https://github.com/iliaal/pdo_duckdb

Still a bit raw, but getting there