v.24.10Experimental Feature

Support for Dynamic Type in Functions

Support for the Dynamic type in most functions by executing them on internal types inside Dynamic. #69691 (Pavel Kruglov).
Added support for the Dynamic data type in most ClickHouse functions by executing them on the internal types contained within Dynamic.

Why it matters

This feature enables users to work seamlessly with the Dynamic type in various functions without manual extraction or conversion. It improves flexibility and usability when handling dynamic or nested data structures, simplifying query development and enhancing functionality.

How to use it

Users can now directly apply most built-in functions to columns of the Dynamic type. The functions automatically operate on the internal data types contained within Dynamic without requiring special syntax or preprocessing.