knex multiple column filters to a join

[AlfieriChou]

example

knex
  .select('*')
  .from('users')
  .leftOuterJoin('accounts', function () {
    this
      .on('users.id', 'account.user_id')
      .on('users.state', 'accounts.state')
  })

SELECT *
FROM 'users'
LEFT JOIN 'accounts'
   ON 'users'.'id' = 'accounts'.'user_id'
   AND 'users'.'state' = 'accounts'.'state'

[AlfieriChou]

knex
  .select('*')
  .from('users')
  .leftOuterJoin('accounts', b1 => b1
      .on('users.id', 'account.user_id')
      .andOn(b2 => b2
         .on('users.state', 'NULL')
         .orOn('users.state', 'accounts.state')
      )
  });