Running native N1QL queries is not supported

[lautarodragan]

Take a look at lib/cb.js:528:

CouchbaseDB.prototype.query = function (sql, callback) {
    debug("CouchbaseDB.prototype.query() model, query: " + JSON.stringify([sql]));
    var self = this;

    callback(null,null);
};

The following will always return null:

Model.dataSource.connector.query(query, (e, r) => {
  console.log(e, r); // both 'e' and 'r' are null
  callback(e, r);
});

[lautarodragan]

Apparently this can be quickly fixed by changing the implementation of CouchbaseDB.prototype.query to the following:

CouchbaseDB.prototype.query = function (sql, callback) {
  debug("CouchbaseDB.prototype.query(): " + JSON.stringify(sql));

  cbquery(sql,this,function(err,res){
    callback(err, res);
  });
};

Not yet tested in production. cbquery does some transformations on the result which might be undesired or not performant:

if(res != null){
  if( Object.prototype.toString.call( res ) === '[object Array]' ) {
    var res2 = [];
    for(var i = 0 ; i < res.length ; i++){
      var row = res[i];
      if(row[self.settings.bucket] && Object.keys(row).length == 1){
        res2.push(row[self.settings.bucket]);
      }else{
        res2.push(row);
      }
    }
    res=res2;
  }
}