Perhaps:<code> sqlite> create table LoveMyZero( nzid integer primary key, znum integer generated always as (nzid-1) virtual, payload text); sqlite> insert into LoveMyZero values (null, "First entry"); sqlite> select * from LoveMyZero; 1|0|First entry sqlite> </code>