node mysql oil在node mysql中实现光滑API

节点-mysql-oil（顶部上的一个光滑的API） Oil通过将JavaScript结构转换为SQL语句，使SQL更加JavaScript化。例如，这个：

var db = require('mysql-oil').connect({db:'db_demo'});

db({

  tselect: 'avg(t_main) as average, sum(t1.amount) as total',

  tfrom: 't_main',

  tjoin: [

    {inner: 't_join1 t1', on: 't1.main_id = t_main.id'},

    {left: 't_join2 t2', on: 't2.join_id = t1.id'}

  ],

  twhere: ['t1.amount > ? AND t_main.cat = ?', 0, 'sale']

});