Sequelize.js - build SQL query without executing it

Question

Is there a way to get Sequelize to build a query with the replacements (so I'll be able to use their SQL injection cleanup) and just get the raw SQL query, without executing it?

Chalkers · Accepted Answer · 2020-01-02 01:43:49Z

4

You can just call the QueryGenerator with the type of query you want to generate. For example a selectQuery:

    const sql = MyModel.QueryGenerator.selectQuery(
        MyModel.getTableName(), {
        where: {
            someAttribute: "value"
        },
        attributes: ["other", "attributes"]
    },
        MyModel);

There's also insertQuery, updateQuery, deleteQuery too.

answered Jan 2, 2020 at 1:43

Chalkers

1,9432 gold badges14 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

seawolf Over a year ago

Might also be MyModel.queryGenerator.

seawolf Over a year ago

I had to use Utils.mapFinderOptions(queryOptions, MyModel) for Sequelize to transform field names to db column names.

Errorname · Accepted Answer · 2018-12-19 11:45:43Z

3

It looks like this feature isn't implemented yet, but there are some users trying to push the issue forward.

See github issue.

answered Dec 19, 2018 at 11:45

Errorname

2,48115 silver badges27 bronze badges

Comments

Andre Pan · Accepted Answer · 2019-07-08 17:13:50Z

2

it's undocumented, but I use next way (Sequelize ver. 5.2.13):

let tableName = myModel.getTableName(options);
let qi = myModel.QueryInterface;
options.type = 'SELECT';
options.model = myModel;
var sql = qi.QueryGenerator.selectQuery(tableName, options, myModel);

answered Jul 8, 2019 at 17:13

Andre Pan

211 bronze badge

Collectives™ on Stack Overflow

Sequelize.js - build SQL query without executing it

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related