ClickHouse version 25.6 introduces a host of updates, including 27 new features, 26 performance optimizations, and 98 bug fixes, while welcoming new contributors to the community. Notable enhancements include the introduction of lightweight SQL UPDATE and DELETE statements that use a patch-part mechanism, significantly boosting performance by applying updates instantly without impacting query performance. The update also features AI-powered SQL generation, improved aggregation processes, and optimizations for JOIN operations, all aimed at enhancing speed and efficiency. Additionally, native support for Geo Parquet types and new geospatial functions have been added, alongside security enhancements that allow for more flexible user provisioning and granular permission settings. These improvements collectively enhance ClickHouse's functionality and efficiency, maintaining its position as a popular choice for data processing and analytics.