So the only way to use the aggregation types that are not listed in MySQL functionalities is to set Database Connection Table Reader and Pivoting instead of Database Pivot Node?
Since I have noticed that as performance the Database nodes seem work quite faster for trasform and filter data when the data processed are in a database format with respect of a table format.