Not sure which version of sqlite you're using but ...
# squarelibraries
d
Not sure which version of sqlite you're using but there's JSON_GROUP_ARRAY.