Partial query build giving string output

[arrafi-ahmed]

Trying to build partial query while working with jsonb, but its printing string in inserted row:

exports.updateEntityLastCount = async ({ pairs, tournamentId }) => {
const keys = Object.keys(pairs);
const vals = Object.values(pairs).map(
(value, index) =>
((entity_last_count ->> ${keys[index]})::int + ${value})::text,
);
const keyArray = sql${keys.join(", ")};
const valArray = sql${vals.join(", ")};

return sql UPDATE tournaments SET entity_last_count = entity_last_count || jsonb_object( ARRAY[${keyArray}], ARRAY[${valArray}]) WHERE id = ${tournamentId};;
};

DB inserted row:
{"group": 1, "match": 1, "phase": "((entity_last_count ->> phase)::int + 1)::text", "bracket": 1}

[robahtou]

@arrafi-ahmed seems like you're missing the key word sql here:

(value, index) => sql`((entity_last_count ->> ${keys[index]})::int + ${value})::text`

whole query:

exports.updateEntityLastCount = async ({ pairs, tournamentId }) => {
  const keys = Object.keys(pairs);
  const vals = Object.values(pairs).map(
    (value, index) => sql`((entity_last_count ->> ${keys[index]})::int + ${value})::text`
  );
  const keyArray = sql`${keys.join(", ")}`;
  const valArray = sql`${vals}`;

  return sql`
    UPDATE tournaments 
    SET entity_last_count = entity_last_count || jsonb_object(
      ARRAY[${keyArray}], 
      ARRAY[${valArray}]
    ) 
    WHERE id = ${tournamentId};
  `;
};