How to update all columns on conflict

[go-jet]

Discussed in #237

^{Originally posted by rsmidt May 17, 2023}
I'm trying to implement a basic upsert where I want to update all fields as soon as I hit a constraint, e.g.

Users.
	INSERT(Users.AllColumns).
	MODEL(user).
	ON_CONFLICT(Users.ID).
	DO_UPDATE(
		SET(Users.AllColumns.SET(Users.EXCLUDED.AllColumns)),
	)

Unfortunately, this doesn't compile. Am I doing something wrong here? Is there maybe a better way to achieve the upsert?

[DevX86]

@go-jet Bump :) Can you take a look at this? Having a MODEL() for updating all columns besides the primary key would be super useful. Or something similar to the implementation above.

Edit for which ones we would want to exclude we could use .Except() as we do with inserts.