sqlite> alter table foo add column baz integer;
sqlite> insert into foo values (40,40,'forty');
sqlite> select rowid, pk, bar, baz from foo;
10|10|ten|
20|20|twenty|
30|30|30|
40|40|40|forty