Concatenate formula on connected records

There are multiple situations where it would be helpful to show a text concatenation of connected records. For instance, all the user names (text) connected to a record and separated by a separator.

If for instance there is an “Asset” that is connected to a “Users” table via an intermediary “Asset Followers”, is could be great to show the list of all the connected user names. It would be the equivalent of the Sum aggregation, but replaced by a concatenation operator. In a Google Spreadsheet this would be a JOIN() operator.