knex queryBuilder code example

Example 1: knex.js count

knex('users').count('active', {as: 'a'})Outputs:select count(`active`) as `a` from `users`

Example 2: knex insert multiple rows

let dataList = bookshelf.Collection.extend({
	model: ModelName,
});

let multipleSaved = dataList.forge([...Your_listOfData]);

multipleSaved
.invokeThen("save")
.then(() => {...})
.catch(err=>{...})