GlobalVariableProblem.js

//declare a promise to handle this treatement
//would be nice to call the same code many times
//use it as a function
Task.spawn(function* () {
    //global variable
    let id=[];
    let db = yield Sqlite.openConnection({ path: myPath});

    try {
        let row = yield db.execute("SELECT id FROM 'plates'");
        
        for ( i=0; i < row.length; i++) {
            console.log("row["+ i +"] :" + row[i].getResultByIndex(0));
            id.push(row[i].getResultByIndex(0));
        }
    }
    finally {
        yield db.close();
    }
    
    //Do whatever it is after the results are in.
    console.log("id length:"+id.length);
    id.forEach((idi, i) => console.log(i, idi));
});

SpaghettiControlFlow.js

//declare a promise to handle this treatement
//would be nice to call the same code many times
//use it as a function
let getIds = Task.async(function* () {
    //global variable
    let id=[];
    let db = yield Sqlite.openConnection({ path: myPath});

    try {
        let row = yield db.execute("SELECT id FROM 'plates'");
        
        for ( i=0; i < row.length; i++) {
            console.log("row["+ i +"] :" + row[i].getResultByIndex(0));
            id.push(row[i].getResultByIndex(0));
        }
    }
    finally {
        yield db.close();
    }
    
    return id;
});

let printIds = function(id) {
    //Do whatever it is after the results are in.
    console.log("id length:"+id.length);
    id.forEach((idi, i) => console.log(i, idi));
};

getIds().then(printIds);