Bookshelf.js/Knex.js innerJoin withRelated

count.js

var Promise = require('bluebird'),
    User    = require('./user'),
    knex, query;

knex = User.prototype._builder(User.prototype.tableName);
    
query = function (q) {
    q.distinct()
        .innerJoin('orders', function () {
            this.on('users.id', '=', 'orders.user_id')
                .andOn('orders.amount', '>', 100);
        })
        .innerJoin('addresses', function () {
            this.on('users.id', '=', 'addresses.user_id')
                .andOn('addresses.state', '=', 'New York');
        });
    return q;
};

Promise.all([
    query(knex.count()).first().then(function (row) {
        return +row.count;
    }),
    User.query(query).fetchAll({ withRelated: ['orders', 'addresses'] })
]).spread(function (count, users) {
    // success
});

count_and_fetch.js

var Promise = require('bluebird');

Model.countAndFetch = function (query, options) {
    return Promise.all([
        query(knex.count()).first().then(function (row) {
            return +row.count;
        }),
        this.query(query).fetchAll(options)
    ]);
};

query.js

User.query(function (q) {
        q.distinct()
            .innerJoin('orders', function () {
                this.on('users.id', '=', 'orders.user_id')
                    .andOn('orders.amount', '>', 100);
            })
            .innerJoin('addresses', function () {
                this.on('users.id', '=', 'addresses.user_id')
                    .andOn('addresses.state', '=', 'New York');
            });
    })
    .fetchAll({ withRelated: ['orders', 'addresses'] })
    .then(function (users) {
        var user      = users.at(0),
            orders    = user.related('orders'),
            addresses = user.related('addresses');
        // do stuff with the user, their orders, and their addresses
    });

Hello,
I have pretty the same code for joins:

var Site = bookshelf.Model.extend({
    tableName: tableName,
    codes: function () {
        return this.hasMany('Code');
    },
    getSitesToParse: function (code) {
        return this
            .query(function (qb) {
                qb.leftOuterJoin('code', function () {
                    this.on('site.id', '=', 'code.site_id')
                        .andOn('code.searchcode', '=', code);
                });
                qb.whereNull('code.searchcode');
                qb.orWhere('code.updated_at', '<', bookshelf.knex.raw("now() - site.refreshminutes * interval '1 minute'"));
            })
            .fetchAll({});
    }
});

but in this line: <.andOn('code.searchcode', '=', code);> bookshelf considers code value as column name and generates this SQL:
"code"."searchcode" = "my value", not "code".searchcode" = 'my value'. And postgress says that there's no column with name "my value".

Solution I've found: .andOn('code.searchcode', '=', bookshelf.knex.raw("'" + code + "'"));