db_version_control.deleted

deleted.md

id	c0	c1	username	version	is_deleted
6	old0	old1	Kevin	2	t

deleted.sql

with deleted as (
select * from join_table
where temp_id is null and data_id is not null
)
insert into temp (c0, c1, username, version, is_deleted)
select c0, c1, 'Kevin', version+1, true
from data
where id in (select data_id from deleted);

select * from temp where is_deleted = true;