SQLite 3.39

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table t1030 (
  id int not null primary key
, tname text
, tdesc text
, tconfirm bool not null
);
✓
insert into t1030 
select 001
  , 'aaa'
  , 'bbb'
  ,ifnull((
    select false
    from t1030
    where tname = 'aaa' 
    and tdesc = 'bbb'
    LIMIT 1
  ),true);
✓
select * from t1030;


id
tname
tdesc
tconfirm


1
aaa
bbb
1


insert into t1030
select a.column1 as id
     , a.column2 as tname
     , a.column3 as tdesc
     , case 
        when a.column2 = 'aaa' and a.column3 = 'bbb' then true
        else false
       end
  from (values (002, 'aaa', 'bbb')
             , (003, 'aaa', 'ccc')) a;
✓
select * from t1030;


id
tname
tdesc
tconfirm


1
aaa
bbb
1

2
aaa
bbb
1

3
aaa
ccc
0