I built myself sql script writer like this, it's pretty fast for my project since my previous PHP Backend is too slow (in my case)

const mysqlLib = require('mysql');
const ENV = require('../configs/env').ENV;
const database = ENV.database;
const mysql = mysqlLib.createPool(database);

function executeQuery(query) {
    return new Promise((resolve, reject) => {
        mysql.query(query, (err, result, fields) => {
            if (err) {
                console.log(query);
                return reject(err);
            }

            resolve(result);
        });
    });
}

function executeQueryGetFirst(query) {
    return new Promise((resolve, reject) => {
        mysql.query(query, (err, result, fields) => {
            if (err) {
                console.log(query);
                return reject(err);
            }

            result = JSON.parse(JSON.stringify(result));

            if (result.length == 0) {
                resolve(null);
            } else {
                resolve(result[0]);
            }
        });
    });
}

var Database = {
    getById(table, id) {
        var query = '';
        query += 'SELECT * FROM ' + table + ' ';
        query += 'WHERE Id = ' + id;
        query += ' LIMIT 1';

        return executeQueryGetFirst(query);
    },
    getAllById(table, id) {
        var query = '';
        query += 'SELECT * FROM ' + table + ' ';
        query += 'WHERE Id = ' + id;

        return executeQuery(query);
    },
    getByAttributes(table, attributes) {
        var query = 'SELECT * FROM ' + table;
        var whereQuery = '';

        for (prop in attributes) {
            if (whereQuery != '') {
                whereQuery += ' AND ';
            }

            if (attributes[prop] == null) {
                whereQuery += prop + ' IS NULL';
            } else {
                whereQuery += prop + ' = "' + attributes[prop] + '"';
            }
        }

        query += ' WHERE ' + whereQuery;
        query += ' LIMIT 1';

        return executeQueryGetFirst(query);
    },
    getAllByAttributes(table, attributes) {
        var query = 'SELECT * FROM ' + table;
        var whereQuery = '';

        for (prop in attributes) {
            if (whereQuery != '') {
                whereQuery += ' AND ';
            }

            if (attributes[prop] == null) {
                whereQuery += prop + ' IS NULL';
            } else {
                whereQuery += prop + ' = "' + attributes[prop] + '"';
            }
        }

        query += ' WHERE ' + whereQuery;

        return executeQuery(query);
    },
    getAll(table) {
        var query = 'SELECT * FROM ' + table;

        return executeQuery(query);
    },
    add(table, attributes) {
        var insertName = '(Id';
        var insertData = '(NULL';

        for (prop in attributes) {
            var value = attributes[prop];
            if (value != null) {
                value = '"' + value + '"';
            }

            insertName += ', ' + prop;
            insertData += ', ' + value;
        }

        insertName += ')';
        insertData += ')';

        var query = 'INSERT INTO ' + table + ' ' + insertName + ' VALUES ' + insertData;

        return executeQuery(query);
    },
    updateByID(table, id, attributes) {
        var query = 'UPDATE ' + table;
        var setQuery = '';

        for (prop in attributes) {
            if (setQuery != '') {
                setQuery += ', ';
            }

            setQuery += prop + ' = "' + attributes[prop] + '"';
        }

        query += ' SET ' + setQuery + ' WHERE Id = ' + id;

        return executeQuery(query);
    },
    updateByAttributes(table, findAttributes, attributes) {
        var query = 'UPDATE ' + table;
        var setQuery = '';
        var whereQuery = '';

        for (prop in attributes) {
            if (setQuery != '') {
                setQuery += ', ';
            }

            setQuery += prop + ' = "' + attributes[prop] + '"';
        }

        for (prop in findAttributes) {
            if (whereQuery != '') {
                whereQuery += ', ';
            }

            whereQuery += prop + ' = "' + findAttributes[prop] + '"';
        }

        query += ' SET ' + setQuery + ' WHERE ' + whereQuery;

        return executeQuery(query);
    },
    deleteById(table, id) {
        var query = 'DELETE FROM ' + table + ' WHERE Id = ' + id;

        return executeQuery(query);
    },
    deleteByAttributes(table, attributes) {
        var query = 'DELETE FROM ' + table;
        var whereQuery = '';

        for (prop in attributes) {
            if (whereQuery != '') {
                whereQuery += ' AND ';
            }

            whereQuery += prop + ' = "' + attributes[prop] + '"';
        }

        query += ' WHERE ' + whereQuery;

        return executeQuery(query);
    }
}

Database.executeQuery = executeQuery;
Database.executeQueryGetFirst = executeQueryGetFirst;

exports.Database = Database;

Env config

var ENV = {
    isDev: true,
    database: {
        connectionLimit: 10,
        host: 'localhost',
        user: 'root',
        password: '',
        database: 'your_database'
    }
}

exports.ENV = ENV;
exports.ENV.port = ENV.isDev ? 15001 : 8887;