This is an ideal case for sequelize.where(sequelize.fn(), {in: []}) however that is not fully supported yet.
For now you might have to use sequelize.literal() and write it raw.

@mickhansen Thanks.
I will appreciate if you give snippets of using:

• sequelize.where(sequelize.fn(), {in: []}) with sequelize.and (is it possible?)
• sequelize.literal with sequelize.and

in findAll request.

@mickhansen
I'm trying to do something similar with

  var fn = Sequelize.fn("UPPER", Sequelize.col("CompanyName"));     
  var where = Sequelize.where(fn, {like: 'B%'});
  customerModel.findAll( where ).then(function(r) { ... });

But am unable to get it to work. Am I missing something, or is there a workaround using sequelize.literal that will accomplish the same thing. Interestingly the query executes but doesn't perform any filtering at all.

@jtraband

return Company.findAll({
    where: Sequelize.where(
      Sequelize.fn("UPPER", Sequelize.col("CompanyName")),
      { like: 'B%' }
    )
  });

Works fine for me on latest master

SELECT `id`, `CompanyName` FROM `companies` AS `company` WHERE UPPER(`CompanyName`) LIKE 'B%';

Thanks, is there any to get this version from npm or do I need to clone the latest git and link it locally. The 2.0.0 rc version i just got from npm does not work.

npm install sequelize/sequelize

@djmadcat Finally fixed :) - See the test in the referenced commit for the required syntax

As a note, to combine .fn-properties and other properties - just use an array for where key.

      where: [
        sequelize.where(
          sequelize.fn('array_length', sequelize.col('patterns'), 1),
          { [Op.gt]: 0 },
        ),
        { companyId: this.companyId },
      ],