Upsert with greylist in updateColumns results in invalid SQL
Author: yourtallnessCreated Jul 30, 2023Updated Dec 21, 2025
Labelsbug
What version of SQLBoiler are you using (sqlboiler --version)?
v4.14.0
What is your database and version (eg. Postgresql 10)
PG 15
Passing a greylist to the update columns in an Upsert operation results in:
sqbmodel: unable to upsert posts: ERROR: syntax error at or near "=" (SQLSTATE 42601)The generated query is invalid, including 2 extra columns fields (I included 2 columns in the greylist):
"created_at" = EXCLUDED."created_at","updated_at" = EXCLUDED."updated_at", = EXCLUDED., = EXCLUDEDSource: aarondl/sqlboiler