Set a column value with an aggregate sum from a JSON column

update_from_aggregate_sum_json.sql

WITH estimate_inter_durations AS (
  SELECT (json_array_elements(estimate_inter.sequences)->>'duration')::float AS duration, estimate_inter.id
  FROM estimate_inter 
  INNER JOIN estimate ON estimate.id = estimate_inter.id
  WHERE estimate.id = estimate_inter.id
)

UPDATE estimate 
SET duration_value = (
  SELECT SUM(duration) 
  FROM estimate_inter_durations 
  WHERE estimate.id = estimate_inter_durations.id 
  GROUP BY estimate_inter_durations.id
);