v.23.5Improvement

Copies embedded examples to the example field in system.functions

Copies embedded examples to a new field example in system.functions to supplement the field description. #49222 (Dan Roscigno).
Adds a new example field to the system.functions table that contains embedded usage examples for functions, supplementing the existing description field.

Why it matters

This feature improves user experience by providing concrete example usages of functions directly within the system.functions metadata. It helps users understand how functions work and how to apply them without needing to consult external documentation.

How to use it

Users can query the example field from the system.functions table to see embedded usage examples for each function. For example, execute:

sql<br>SELECT name, example FROM system.functions WHERE name = 'function_name'<br>
to obtain examples alongside descriptions.