SequelizeJS - How to Map Nested (eager loading) Models for Raw Queries?

Question

Below is an example of a raw query.

  const query = `SELECT 
    links.name, links.type, links.code, links.originalUrl,
    domains.id as 'domain.id', domains.host as 'domain.host',

    count(
      CASE WHEN hits.datetime > "${past}" AND hits.datetime <= "${now}" = true then 1 END
    ) as hitCount 

    FROM links

    LEFT JOIN hits ON links.id = hits.linkId
    LEFT JOIN domains ON links.domainId = domains.id

    WHERE links.userId = ${req.user.id}

    GROUP BY links.id, hits.linkId

    ORDER BY hitCount DESC

    LIMIT 5`;

  const links = await sequelize.query(query.trim(), { 
    type: sequelize.QueryTypes.SELECT,
    model: Link,
    mapToModel: true
  });

I am mapping the query result into the model Link with mapToModel: true. It works well but when I try to get some data from a joined table and map that into an object in model it doesn't convert into array.

For example I am trying to get domains like domains.id as 'domain.id', domains.host as 'domain.host', This is how I saw sequlize does the query for eager loaded data.

But when I get the result object the I don't get a nested domain object property.

// desired link object
{
   id: 3,
   name: 'My test link',
   domain: {
      id: 23,
      host: 'example.com'
   }
}

instead what I get is

// current link object
{
   id: 3,
   name: 'My test link',
   'domain.id': 23,
   'domain.host': 'example.com'
}

So nested objects aren't mapping correctly.

UPDATE

I have found nest options in query() documentation but setting nest: true doesn't seems to have any effect.

Changed Query

  const links = await sequelize.query(query.trim(), { 
    type: sequelize.QueryTypes.SELECT,
    model: Link,
    mapToModel: true,
    nest: true, // doesn't have any effect
  });

Answer 1

For me nest worked only in conjunction with raw:

  const links = await sequelize.query(query.trim(), { 
    type: sequelize.QueryTypes.SELECT,
    model: Link,
    mapToModel: true,
    nest: true,
    raw: true // Without this `nest` hasn't effect, IDK why
  });

Answer 2

I have run into the same problem. My solution was:

return sequelize.query(/* query */, {
    nest: true,
    type: sequelize.QueryTypes.SELECT
});

As you see, you should not set mapToModel prop, just nest and type.