Increment or Decrement value using Sequelize upsert() does not work in postgre

[hegdd]

Issue Description

In Sequelize with a postgre Database I am using upsert() to insert a new row if it doesn't exist or increment one of its field values by some other value if it exists.

It dose not work

    this.userBalanceModel.upsert({
      address: 'address',
      chainId: 'chainId',
      balance: literal(`balance + 1`) as any
    },{
      fields: ['balance'],
      conflictFields: ['address', 'chainId']
    })

I found a similar closed issue and it showed that it had been fixed in mysql, but I am still experiencing this similar issue in postgre
#12834

What is actually happening?

Environment

• Sequelize version: v6.35.2
• Node.js version: v18.16.0

[ephys]

That PR landed in Sequelize 7, but you're on Sequelize 6. I'm not aware of this feature being available in Sequelize 6