{'fraction_non_alphanumeric': 0.01488833746898263, 'fraction_numerical': 0.0, 'mean_word_length': 4.8478260869565215, 'pattern_counts': {'":': 0, '<': 0, '<?xml version=': 0, '>': 0, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
Explicit and Implicit LIST Aggregate Function for Relational Databases

We argue for a new aggregate function we termed the LIST function. It aggregates a set of values of one or more attributes into a single value that is internally a list of these values, perhaps ordered. The principle may seem a formal twist, but should be useful in practice. It overcomes important limitations of the current relational systems, due to the use of relations in first normal form, and the separation between the aggregate and the individual data values in the standard SQL. LIST function can be made often implicit, making its use even less procedural. The function should be basically simple to implement. The relational systems already provide most of the capabilities it requires to the existing aggregate functions.