title: Sequelize: Concat fields in WHERE LIKE clause
body: <p>I am using the sequelize ORM for a node.js project I am working on. One query I have, I need to perform a like operation on the concatenated result of multiple columns.</p>
  
  <p>For instance, something like the following:</p>
  
  <p>SELECT * FROM People WHERE (CONCAT(firstname, ' ', lastname)) LIKE '%John Do%'.</p>
  
  <p>I am using the following syntax and would like to know if this is possible without having to resort to using RAW queries (which is nowhere else in my solution).</p>
  
  <pre><code>   var criteria = {
          include: [
              occupation
          ],
          where: {
              is_active: 1
          },
          nest: false
      };
  
      db.people.findAll(criteria, {}).then(function(people) {
          success(people);
      }).catch(function(err) {
          error(err);
      });
  </code></pre>
  
  <p>Any ideas?</p>