Idea: add async-await in a (preliminary) simple way

[SinanGabel]

function sqlAll(sql_statement) {
    return new Promise((resolve, reject) => { 
        DB.all(sql_statement, (err, rows) => { return (err) ? reject(err) : resolve(rows); });
    });
}

async myFunction(...) {

  // possibly some .js code

  try {
      const rows = await sqlAll('select * from mytable;');
  catch (err) {
     console.error(err);
  }

  // possibly more .js code
}

[SinanGabel]

// Parallel execution:
const all_results = await Promise.all([ sqlAll(stmt1), sqlAll(stmt2), sqlAll(stmt3) ]);

// Serial execution:
const result1 = await sqlAll(stmt1); 
const result2 = await sqlAll(stmt2); 
const result3 = await sqlAll(stmt3); 

[wmertens]

See also https://github.com/StratoKit/strato-db/blob/master/src/DB/SQLite.js which provides a Promise API for node-sqlite3

[daniellockyer]

Closing in favor of #834