I have this query:

-- :name do-update-feed-title! :<!
update articles set meta = meta::jsonb - 'feed-title' ||
--~ (format "{\"feed-title\": %s}" (:title params))
where source = :source;

Parameter Mismatch: :  parameter data not found.

I need to produce something like:

update articles set meta = meta::jsonb - 'feed-title' || '{"feed-title":"Pharmaceutical Business Review - Drug Discovery"}'
where source = '';

@borkdude It might be that you need to escape that colon, since clojure expressions can return hugsql parameters to be evaluated.

Might need two, since it's in a string already:

--~ (format "{\"feed-title\"\\: %s}" (:title params))

https://www.hugsql.org/#colon

@curtis.summers That's it, thanks