seq.js

const sequelize = hook.app.get('sequelizeClient');
const queryExample = ```
UPDATE a
SET [Role]= 'Admin' 
FROM UserRoles a
WHERE a.[Role]= 'Administrator'
AND NOT EXISTS 
  (
       SELECT NULL 
       FROM dbo.UserRoles b 
       WHERE b.[User] = a.[User] AND b.[Role] = 'Admin'
  );
```
sequelize.query(queryExample, {
    type: sequelize.QueryTypes.UPDATE
}).then(function (response) {
    //response
}).catch((error) {
    //error
});