groupConcat method Null safety

Expression<String?> groupConcat({String separator = ','})

Returns the concatenation of all non-null values in the current group, joined by the separator.

The order of the concatenated elements is arbitrary. If no non-null values exist in the group, NULL is returned.

See also:

• the sqlite documentation: https://www.sqlite.org/lang_aggfunc.html#groupconcat
• the conceptually similar Iterable.join

Implementation

Expression<String?> groupConcat({String separator = ','}) {
  const sqliteDefaultSeparator = ',';
  if (separator == sqliteDefaultSeparator) {
    return _AggregateExpression('GROUP_CONCAT', this);
  } else {
    return FunctionCallExpression(
        'GROUP_CONCAT', [this, Variable.withString(separator)]);
  }
}