RunKit + npm: knex

const Knex = require('knex'); const knex = Knex({ client: 'pg', }); knex('store_failure_log') .select('id', 'reviewed', 'log_reference', knex.raw('CONVERT(?? USING utf8)', ['notification']), 'create_time', 'update_time', 'store', 'user_id') .where('reviewed', 0) .where(knex.raw('?? BETWEEN NOW() - INTERVAL 18 HOUR AND NOW()', ['create_time'])).toSQL()