GROUP_CONCAT, LISTAGG or some other name, depending on the SQL dialect, is an aggregation function which takes values from several rows and lists them in a single string, separated by some pre-defined ...
MySQL has a default value for group_concat_max_len of 1024, which isn't all that much, especially when emulating MULTISET using JSON. We should increase the value to something much bigger, e.g. set ...