promises.js

db.all('SELECT `chat`.`chat_identifier`,`chat`.`ROWID`,`chat`.`service_name` FROM `chat`').then(chats => {
            chats.forEach(chat => {
                db.all(`SELECT message.text,message.\`is_from_me\`,message.service,message.date FROM chat_message_join INNER JOIN message ON chat_message_join.message_id = message.ROWID WHERE chat_message_join.chat_id = ${chat.ROWID} ORDER BY message.date ASC`).then(messages => {
                    addThread(chat.chat_identifier, chat.ROWID, chat.service_name, messages)
                });
            });
        });