Atomic scalar list operations

[jonahsnider]

Problem

Scalar lists only support setting a value

This results in a less pleasant developer experience as well as potential data loss from race conditions.

Suggested solution

Add push (add elements) and pull (remove elements) operators.
Maybe also a pop operator.

Some thought should be put into the syntax used to push 1 element or 1+ elements. MongoDB uses an object with the $each operator:

db.students.update(
   { name: "joe" },
   { $push: { scores: { $each: [ 90, 92, 85 ] } } }
)

Additional context

Database documentation for array updates:

• MongoDB
• PostgreSQL

[jonahsnider]

Just realized this is a (partial?) duplicate of #5078 and is partially solved by prisma/prisma-engines#1753.

[pantharshit00]

I will consider it as full duplicate of #5078 and it will available in the next release(which will hopefully happen on Tuesday 31-03. For deletion, you will need to use set as you can't uniquely identify them and there can be duplicates so it will be application specific logic.