eg:

CREATE TABLE Person (id integer primary key,name text);

CREATE TABLE P('name');

insert into P('name') values ('Ansel'),('Joy'),('Lili');

insert into Person('name') select namefrom P;

select * from Person;

id name

---------- ----------

1 Ansel

2 Joy

3 Lili