ClickHouse v22.2 has been released, bringing several exciting features including production-ready projections, custom deduplication, and flexible memory limits. Projections allow users to store part of a table in a subdirectory with a different sorting key or aggregating the original data. Custom deduplication on insert allows for more control over deduplication, while default table engines can now be set, making it easier to create tables without specifying an engine. Ephemeral columns can be used at insert time to calculate other columns, and text classification functions have been added for detecting language, character set, tonality, and programming language. Implicit casting in dictGet* functions simplifies queries. Meetups and webinars have taken place, including a virtual meetup with Contentsquare and a webinar on the new features released in v22.02. Upcoming webinars include the ClickHouse v22.3 release webinar. The Query of the Month highlights the power of window functions, showcasing examples such as comparing cohort averages, finding previous records, and sorting with window functions. Reading Corner features articles on scaling out ClickHouse clusters, analyzing financial data with ClickHouse, and the latest ClickHouse release blog post. New adopters include Gigasheet.