INSERT OR REPLACE INTO TABLE name (f1, f2, f3) VALUES (v1, v2, v3)

嗯，看错题了，我还以为是insert or update，结果是select or insert。

select or insert除了开transaction之外，我一时也没想出什么好办法，不过倒是有个select with default value的方案

 select id, f1, f2 from sometable where id=3 union
select 999 as id, 'default_value1' as f1, 'default_value2' as f2
where not exists (select 1 from sometable where id=3)

999是id的default value