Knex.js paginated query string.

knexQuery.js

  app.get('/api/:id', function(req, res) {
    var query = req.params.id.toLowerCase();
    knex.select('*').from('table').where('name', 'ilike', '%'+query+'%').limit(5).offset(30).orderBy('id', 'desc')
    .then(function(rows){
          res.send(rows);
        });
  });