#1292·sqlboiler

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., = EXCLUDED