db_version_control.no-change

no-change.md

temp_id	temp_c0	temp_username	temp_version
4	old2	Eric	2

no-change.sql

-- no change
with no_change as (
select * from join_table
where temp_id is not null and data_id is not null
)
-- set is_deleted to true, username to modifier for deleted data
update temp set username = 'Kevin'
where id in (select temp_id from no_change);

-- see which data is unchanged
with no_change as (
select * from join_table
where temp_id is not null and data_id is not null
) select temp_id, temp_c0, temp_username, temp_version from no_change;