android sqlite json,android - Convert SQLite to JSON - Stack Overflow

sqlite, already have json1 extension, you could use:

//https://www.sqlite.org/json1.html

//https://gist.github.com/akehrer/481a38477dd0518ec0086ac66e38e0e2

var _sql = "SELECT json_group_array( json_object('id', id, 'name', name) ) AS json_result FROM (SELECT * FROM ipfs ORDER BY id); ";

sql.js does not support json1 extension,

my working example convert raw record to json

function json1_extension(_records){

var _json = [];

var _columns = _records[0].columns

var _values = _records[0].values

for (var i = 0; i < _values.length; i++) {

//console.log(_values[i]);

var _row_json = {};

var _row = _values[i];

for (var k = 0; k < _row.length; k++) {

_row_json[_columns[k]] = _row[k]

}

//console.log('_row_json...',_row_json);

_json.push(_row_json)

}

return _json

}