SQLite 3.8

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

create table t as
    select 1 as id, 2 as x union all
    select 2, 1 union all
    select 3, 5
select rowid, t.*
from t


rowid
id
x


1
1
2

2
2
1

3
3
5


select *
from t


id
x


1
2

2
1

3
5


insert into t(x) values (10)
select *from t


id
x


1
2

2
1

3
5

null
10

id	x
1	2
2	1
3	5
null	10