Description
In SPARK-24035, to conform with Oracle PIVOT syntax, a strict check of PIVOT's aggregate expressions was exerted, which allows only an AggregateExpression with or without alias. Now we would like to relax the check to allow complex aggregate expressions, like ceil(sum(col1)) or sum(col1) + 1