How do I query for two columns to be equal using Sequelize?

Question

db.WorkbookQuestion.count({
  where: {
    QuestionId: dbQuestion.id,
    AnswerSelectedId: db.sequelize.col('CorrectAnswerId')
  }
});

The query generates this SQL: SELECT count(*) AS "count" FROM "WorkbookQuestions" AS "WorkbookQuestion" WHERE "WorkbookQuestion"."QuestionId" = 1103 AND "CorrectAnswerId";

How do I get it to be more like AnswerSelectedId = CorrectAnswerId?

Answer 1

I was stuck on this for a while today until I found this answer. I also found another way of doing the same query so will leave another answer here.

db.WorkbookQuestion.count({
  where: {
    CorrectAnswerId: {
        $col: 'AnswerSelectedId'
    }
  }
});

Answer 2

Update: Another way of writing code by using Operators(Op) from sequelize.

const { Op } = require('sequelize');

db.WorkbookQuestion.count({
  where: {
    QuestionId: dbQuestion.id,
    CorrectAnswerId: {
        [Op.eq]: sequelize.col('AnswerSelectedId')
    }
  }
});