SQL updates in ClickHouse 26.3
Mark Needham
ClickHouse 26.3 adds several SQL quality-of-life improvements. In this video, Mark walks through five new features:
- naturalSortKey() — sorts strings like version numbers in the order humans expect
- JSONExtractString and has() now work with the native JSON type
- EXPLAIN pretty and compact options for readable query plan output
- NOW, CURRENT_DATE, CURRENT_TIMESTAMP without parentheses (SQL standard compatibility)
- caseFoldUTF8, removeDiacriticsUTF8, normalizeUTF8NFKCCasefold — new Unicode string functions
More from the 26.3 release: https://clickhouse.com/blog/clickhouse-release-26-03
Open House
Scaling ClickHouse to petabytes of logs at OpenAI
Open House
How ClickHouse helps Anthropic scale observability
Open House, User stories
How Capital One cut infrastructure costs by 50%
Engineering leaders at Capital One share how they cut infrastructure costs by 50% and reduced average dashboard load time from 5+ to under 500ms with ClickHouse Cloud.
