(async () => {
    const sqlite3 = require('sqlite3').verbose();

    let db = new sqlite3.Database('mydb.db', (err) => {
      if (err) {
        console.error(err.message);
      }
      console.log('Connected to the database.');
    });


    function get_playlists(db) {
        return new Promise( (resolve, reject) => {
            let sql = `SELECT DISTINCT Name name FROM playlists ORDER BY name`;

            db.all(sql, [], (err, rows) => {
                if (err) { throw err; }
                resolve(rows);
            });
        })
    }

    let rows ;

    let res = await get_playlists(db)
    rows = res;
    rows.forEach( (row) => { console.log('row:', row) } );
    let result = rows;
    console.log('result', result);
    db.close();

})();