According to the docs it’s possible to do an “insert, if exists update operation” through writePolicy.
Is it possible to get back the resulting behavior from such a query, to know whether the record already existed or not?
You can do that using a RecordUDF.