About scalar functions: could such functions be used only as transform function, or could be applied to the result of aggregation? Eg to return the greater value of two

PERCENTILETDIGEST50

yes, post aggregation transform functions are supported