SQL middleware framework

example.js

/* Run SQL query group */
var move_player = sql.group(
    sql.query(['next_number'], 'SELECT MAX(number)+1 AS number FROM reg WHERE game_id=:game_id'),
    sql.query(['old_user_id'], 'SELECT user_id FROM reg WHERE number=:old_number AND game_id=:game_id'),
    sql.query(['new_user_id', 'new_reg_id'], 'SELECT user_id, reg_id FROM reg WHERE number=:new_number AND game_id=:game_id'),
    sql.query('DELETE FROM player WHERE reg_id=:new_reg_id AND game_id=:game_id LIMIT 1'),
    sql.query('DELETE FROM reg WHERE reg_id=:new_reg_id AND game_id=:game_id LIMIT 1'),
    sql.query('DELETE FROM auth WHERE user_id=:old_user_id AND game_id=:game_id LIMIT 1'),
    sql.query('UPDATE reg SET user_id=:new_user_id WHERE user_id=:old_user_id AND game_id=:game_id'),
    sql.query('UPDATE auth SET user_id=:new_user_id WHERE user_id=:old_user_id AND game_id=:game_id')
);

move_player({'game_id':1, 'old_number':14, 'new_number':130}, function(err) {
    if(err) console.log('Failed to move player');
    else console.log('Successfully moved players');
});