The closest thing in sqlite is [group_concat](https://www.sqlite.org/lang_aggfunc.html). Maybe there's an extension that provides this? sqlean doesn't have it.