Sequelize numeric type returns as string?

Question

Node.js

I am using PostgreSQL. The SUM("Statistics"."quantityPrinted") AS "quantityPrinted" function returns a string value.

const response = await models.sequelize.query(
    `
    SELECT
      SUM("Statistics"."quantityPrinted") AS "quantityPrinted"
    FROM "Cartridges"
    left JOIN "Statistics" on "Statistics"."cartridgeId" = "Cartridges".id
    WHERE "Cartridges".id = 2
  `,
    { type: models.sequelize.QueryTypes.SELECT }
);

Changed settings, but only works for MySQL.

dialectOptions: {
    supportBigNumbers: true,
    bigNumberStrings: false
  }

PS Actually, I have a much more complicated query that cannot be built using ORM.

Answer 1

Found a simple solution

const pg = require('pg');

// https://github.com/sequelize/sequelize/issues/4550
pg.defaults.parseInt8 = true;

Answer 2

big numbers are expected there?
SELECT cast(SUM("Statistics"."quantityPrinted") as integer) AS "quantityPrinted" won't work?