How to pass order info to sequelize.js raw query?

Question

In sequelize, I can use

my_table.findAll({ order: [['datetime', 'desc']] }) 

to query data and order by a column. But when I try to use parameterized raw query like:

var input_parameters = {order_column: 'datetime', order: 'desc'};

sequelize.query('select * from my_table order by :order_column :order',     { replacements: input_parameters, type: models.sequelize.QueryTypes.SELECT });

It can't return the correct order because the order info asc/desc is escaped in the query, the final prepared query is like 'select * from my_table order by 'datetime' 'desc''.

Is there a way to pass order info to raw parameterized query?

Answer 1

This might not be the sequelize way, but...what if:

let order_column = 'something';
let order = 'DESC';

sequelize.query(`select * from my_table order by ${order_column} ${order}`, { type: models.sequelize.QueryTypes.SELECT });

UPDATE: This is the right answer

await sequelize.query(
  'SELECT * FROM projects ORDER BY ? ?',
  {
    replacements: ['something', 'desc'],
    type: QueryTypes.SELECT,
  }
);

This way sequelize still protects you from sql injection.