As of 21.11 you can't define aggregated or window functions. Only regular.

There are two types of functions:

• lmabda as expression - they are just substituted in expression.
• external executable