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 values
(001, 'aaa', 'bbb'
, case 
  when tname = 'aaa' and tdesc = 'bbb' then true
  else false
  end);

{
  "code": "SQLITE_ERROR"
}


insert into t1030
select id, tname, tdesc
     , case 
        when tname = 'aaa' and tdesc = 'bbb' then true
        else false
        end
  from (select a.column1 as id
             , a.column2 as tname
             , a.column3 as tdesc
          from (values (001, 'aaa', 'bbb')) a) b;
✓
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