appsmith: [Bug]-[2960]:MongoDB update query is not accepting valid value (an array) in update field

Is there an existing issue for this?

• I have searched the existing issues

Current Behavior

This query is valid for MongoDB 4.2+

db.getCollection('user').updateOne(
    {"_id":"1"    },
    [{"$set":{"newField":"$name"}}]
)

And in order to work correctly the $set part needs to be in an array. But when we try to do something similar via Appsmith, It throws an error:

Hint

https://github.com/appsmithorg/appsmith/pull/12241#discussion_r844997566

Steps To Reproduce

Like the Image above:

1. Create an update query in a MongoDB datasource
2. Enter an update statement in array form like this one [{"$set":{"testField":"$status"}}]
3. It fails when you run the query with this error: Execution failed with status 5005 No valid mongo command found. Please select a command from the "Command" dropdown and try again

Environment

Production

Version

Cloud