Can I specify the table when using sequelize.col?

Question

My query looks something like

({
  attributes: [[sequelize.fn('COUNT', sequelize.col('id')), 'commitCount']],
  include: [
    {
      model: global.mysqlDb.Commit,
      attributes: ['id'],
      where: {
        RepositoryId: req.params.repositoryId
      }
    }, {
      model: global.mysqlDb.SourceFile
    }
  ],
  group: ['SourceFileId']
});

But the id in the sequelize.col is ambiguous because it could be from any of the tables. Any way for me to specify the table name as well?

Answer 1

You should be able to do sequelize.col('table.column') and then it will automatically be quoted