What's New in pg_clickhouse - JSONB Support, SQL value functions, Streaming, and more

The pg_clickhouse extension has been well-received by the community for enabling queries on ClickHouse databases via Postgres, prompting continuous improvements and feedback-driven updates. Key advancements include enhanced pushdown capabilities for JSONB accessors, SQL value functions, and array functions, allowing efficient query processing by converting Postgres operations into ClickHouse-compatible syntax. This approach optimizes query execution by pushing down operations to ClickHouse, reducing the load on Postgres. Version v0.2.0 introduces support for current date and time functions, ensuring better synchronization with Postgres time zone settings. Additionally, the extension now supports query result streaming, addressing memory consumption issues associated with large data sets by efficiently managing the handling of results. Future developments are hinted at, including support for window function pushdown and regular expression compatibility, with ongoing community engagement reflected in events like PGConf.dev to share insights gained from building the Foreign Data Wrapper.