system.functions

Contains information about normal and aggregate functions.

Columns:

• name(String) – The name of the function.
• is_aggregate(UInt8) — Whether the function is aggregate.

Original article