Issue with List of unique value

while using list of unique in custom measure, it automatically does an array_sort and also array_join with |record| upon it instead of plain aggregation.  Have attached the screenshot of the generated SQL in data pane.

Screenshot 2023-09-25 at 5.53.02 PM.png

0 0 62