Postgres 12

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table some_table (id integer primary key, product_id integer, enabled boolean, some_value int);
insert into some_table (id, product_id, enabled, some_value)
values 
(1, 100, true, 42),
(2, 100, false, 100),
(3, 101, true, 12);
3 rows affected

with old_data as (
  select id, to_jsonb(t) as old_value
  from some_table t
  where product_id = 100
), new_data as (
  update some_table
     set enabled = false,
         some_value = 4
  where product_id = 100
  returning id, to_jsonb(some_table) - 'id' as new_value
)--, changed_column_values as (
select x.*
from new_data nd
  join old_data od using (id)
  join lateral (
    select nd.id, n.col as column_name, o.value as old_column_value, n.value as new_column_value
    from jsonb_each_text(nd.new_value) as n(col, value)
      join jsonb_each_text(od.old_value) as o(col, value) on o.col = n.col and n.value is distinct from o.value 
  ) x on x.id = nd.id;


id
column_name
old_column_value
new_column_value


1
enabled
true
false

1
some_value
42
4

2
some_value
100
4