SQLite 3.39

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table t1030b (
  id int not null primary key
, tname text
, tdesc text
, tconfirm bool not null
);
✓
replace into t1030b 
select a.column1 as id
     , a.column2 as tname
     , a.column3 as tdesc
     , case 
        when a.column2 = t.tname and a.column3 = t.tdesc then true
        else false
       end
  from (values (1, 'aaa', 'bbb')
             , (2, 'ccc', 'ddd')) a
  left join t1030b t
    on a.column1 = t.id;
✓
select * from t1030b;


id
tname
tdesc
tconfirm


1
aaa
bbb
0

2
ccc
ddd
0


replace into t1030b 
select a.column1 as id
     , a.column2 as tname
     , a.column3 as tdesc
     , case 
        when a.column2 = t.tname and a.column3 = t.tdesc then true
        else false
       end
  from (values (1, 'aaa', 'bbb')
             , (2, 'ccc', 'ddd')
             , (3, 'eee', 'fff')
             , (4, 'ggg', 'hhh')) a
  left join t1030b t
    on a.column1 = t.id;
✓
select * from t1030b;


id
tname
tdesc
tconfirm


1
aaa
bbb
1

2
ccc
ddd
1

3
eee
fff
0

4
ggg
hhh
0