RunKit + npm: knex

const Knex = require('knex'); const knex = Knex({ client: 'pg', }); knex.table('rides').whereRaw('user_id = ? AND completed = ? AND YEAR(created_at) >= ? AND YEAR(created_at) <= ? AND total_cost <=> deposit', ["30fb73d0-9e3d-11e9-bd80-3741ce1df8fb", 1, 2018, 2019]).select('id', 'total_cost', 'driver_id').toSQL();