npm install @kaishen/orm --save
or
yarn add @kaishen/orm

//import
import orm from '@kaishen/orm';

//require
let orm = require('@kaishen/orm');

// You can initialize the configuration at project startup
const database = new orm({
    host: 'localhost',
    username: 'root',
    password:'123456',
    database: 'test',
    port: 3306,
});

database.table('players')
    .select()
    .column('id')
    .column('name')
    .where('id = ?', 100)
    .finish()
    .exec();

select id, name from players where id = 100;

database.table('players')
    .insert()
    .values({id: '100', name: 'kai'})
    .finish()
    .exec();

insert into players (id, name) values('100', 'kai');

database.table('players')
    .update()
    .set({name: 'kai2'})
    .where('id = ?', 100)
    .finish()
    .exec();

update players set name='kai2' where id = 100;

database.table('players')
    .delete()
    .where('id = ?', 100)
    .finish();

delete from players where id = 100;