NodeJS

duck.js

async function getMessages(login, loginMy) {
    if (!login || !loginMy) {
        throw new TypeError('param login and loginMy should be present');
    }

    const resp = await connection.query(`SELECT * FROM messages WHERE fromU = '${login}' AND toU = '${loginMy}' UNION SELECT * FROM messages WHERE fromU = '${loginMy}' AND toU = '${login}' ORDER BY date DESC`);
    
    return resp.map(value => Object.assign({
        from: value.fromU,
        to: value.toU,
    }, value, { fromU: undefined, toU: undefined }))
}