How to write recursive query in sequelize

Viewed 29

can anybody help me to write a recursive query in sequelize?

I can able to write query direct in PostgreSQL database, but unable to write in sequelize

1 Answers

The only way is to use query method of the Sequelize instance to execute a raw SQL query with WITH RECURSIVE as you already did directly.

const results = await sequelize.query('WITH RECURSIVE <rest of the query here>',
  { type: QueryTypes.SELECT });
Related