The common basic usage is fairly simple to translate:
- MySQL (docs):
GROUP_CONCAT( field_name SEPARATOR 'some_separator' )
- SQLite (docs):
GROUP_CONCAT( field_name, 'some_separator' )
Technically the MySQL implementation is has more options, but I suspect the above covers the majority of uses.