Raw query from Sequelize

Question

Is there a method or property that I can see the raw query that is going to be executed on my MS SQL DB when I execute the findAll.

var sql= {where: query.id,
        attributes: queryAttrb,
        include: [
            {
                model: queryModel,
                where: dboQuery.spiStatus
            }]};

model.findAll(sql);

Possible duplicate of [How can I see the SQL generated by Sequelize.js?](http://stackoverflow.com/questions/21427501/how-can-i-see-the-sql-generated-by-sequelize-js) — Ryan Wheale, Jan 04 '17 at 01:36

score 0 · Answer 1 · answered Jan 04 '17 at 14:25

0

Just add logging:

var sql = {
    where: query.id,
    attributes: queryAttrb,
    include: [
        {
            model: queryModel,
            where: dboQuery.spiStatus
        }],
    logging: console.log
};

model.findAll(sql);

answered Jan 04 '17 at 14:25

Adam

4,985
2
29
61

how / where do you defined queryModel? – luis Nov 01 '20 at 22:47

Raw query from Sequelize

1 Answers1