update_call_source_partners.sql

UPDATE call_source_partners
SET affiliate_slug = params_table.affiliate_slug, category_id = params_table.category_id
FROM (
  SELECT id, params->'affiliate_slug' AS affiliate_slug, to_json(params->'category_id')::text::int AS category_id
  FROM call_source_partners 
) AS params_table
WHERE call_source_partners.id = params_table.id;