Loosen INSERT UNLESS CONFLICT cannot be used on properties or links that have a rewrite rule specified

[Gobot1234]

I have a rewrite on an email field that lowers them. This however is preventing me from using unless conflict.

e.insert(e.users.User, fetchUser()).unlessConflict(
    // if the user has a new ucard number e.g. they are a post grad researcher or re-registered, update their associated ucard
    (user) => ({
      on: user.email,
      else: e.update(user, () => ({
        set: {
          ucard_number: ldapLibraryToUcardNumber(ucard_number),
          username: ...,
          organisational_unit: ...,
        },
      })),
    }),
  ),
})

There is currently AFAICT no way to accomplish anything like this even using other features (insert ?? update or if exists then update else insert) as they seem to rewrite themselves to an unless conflict. I'm not really too fussed what changes here I just want to be able to do this in edgeql in one go compared to sending multiple queries and using app logic to do it.

Discord thread: https://discord.com/channels/841451783728529451/1309279819359584397

[msullivan]

There is currently AFAICT no way to accomplish anything like this even using other features (insert ?? update or if exists then update else insert) as they seem to rewrite themselves to an unless conflict.

I don't think that is true? What messages are you getting.

[Gobot1234]

I just checked this in the REPL and ?? chaining worked so maybe it was a client issue. Will report back

[Gobot1234]

Apologies @msullivan, ignore my previous comment, I was checking insert and select which works fine with ??
This is the error you get