Sequelize exclude belongs-to-many mapping object

Question

Is there a way when making a SequelizeJS query on an object, and including a relation which has a belongs-to-many association, to have the included property not return the association mapping object with the result?

i.e.:

Users.findAll({include: [{model: Role, as: 'roles'}]})

//yields objects of the following form
user: {
    username: 'test',
    roles: [
        {
           name: 'user',
           UserRoles: {userId: 1, roleId: 1} //<--I do not want this
        }
    ]        
}

Answer 1

Found a solution to this in a github comment: https://github.com/sequelize/sequelize/issues/4074#issuecomment-153054311

gist:

Users.findAll({
    include: [
        {
            model: Role, 
            as: 'roles',
            through: {attributes: []} //<-- this line will prevent mapping object from being added
        }
    ]
});

Answer 2

You can try specifying the attributes property.

So to include fields say a,b,c you add

attributes: ['a', 'b','c']

To exclude them

attributes:{exclude:['a', 'b','c']}

So findAll looks like

Model.someModel.findAll({
  where: // some condition
  include: // some other model
  attributes: // some fields
})

You can also specify attributes within the include clause