sqlboiler
sqlboiler copied to clipboard
Upsert with greylist in updateColumns results in invalid SQL
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
Can you add an example schema and code?