Performing group_concat queries over distinct values, with a custom delimiter, with SQLite (2 mins read).

How to avoid SQLite's DISTINCT aggregates must have exactly one argument error when performing a group_concat(distinct ...) with a custom delimiter.