ClickHouse gets more SQL compatible in 26.4

Mark Needham

ClickHouse 26.4 adds several standard SQL syntax features that make it more compatible with Postgres and other SQL databases.

• EXTRACT with Postgres-style units: EPOCH, DOW, DOY, ISODOW, ISOYEAR, CENTURY, and more
• SQL-standard compound intervals: INTERVAL '1:30' HOUR TO MINUTE, INTERVAL '1-6' YEAR TO MONTH
• SET TIME ZONE using the SQL-standard alias
• OVERLAY ... PLACING ... FROM ... FOR keyword syntax
• VALUES as a table expression with column aliases: FROM (VALUES (1, 'a')) AS t(id, val)
• NATURAL JOIN — automatically joins on all shared column names and deduplicates them in the output

More from the 26.4 release: https://clickhouse.com/blog/clickhouse-release-26-04