RFE: SQL - Add listagg aggregate function


may I ask You in SQL language module to add "listagg" function into the aggregate (group by...having) SQL queries?

This would help me to identify unique type of logs using this style of aggregation of string columns. Currently I do not see any workaround for this. Implementation of listagg could be a very simple one, it is not necessary to implement all features like e.g. Oracle has (just column, null ignore, order, glue string).

It could be also nice, from performance point of view, to have another string function "hash", which can calculate e. g. SHA256 hash string for such listagg output rather to handle whole string concatenation.

Regards, Stepan

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.