I'm working with SQLite, and when I do a select and transform the result into a list, the list separates the fields by ',' and this gets confused with string fields that also have ',' is it possible to change the list delimiter to another character?
First confirm which SQLite extension you are working with ?
To "challenge" your enquiry:
fields containing a , should not present an issue, they should be surrounded by double quotes ?
You should be able to enforce quotes in your output:
"SELECT quote(name), quote(mobile), quote(email) FROM contacts"
Show examples of sqlite table data, query and output from a query.