sequelize/sequelize-typescript

I can't replace certain columns

Gustazx opened this issue · 1 comments

In sequelize raw queries, if i want to do a replace in certain columns that no needs quotes, i can't disable this quotes to use in my context

Example:

const query = "SELECT * FROM users u ORDER BY :field :order"


const items = await this.sequelize.query(query, {
    replacements: {
    field: "u.name",
    order: "ASC",
    }
});

the query would be SELECT * FROM users u ORDER BY N'u.name' N'ASC'
causing a syntax error in database

Is there a method that i can disable this ?

I need to concatenate to solve this problem; I believe a method for this would be convenient.