INSERT … SELECT

Also written: INSERT INTO … SELECT

An insert that takes its rows from a query. It is used to copy rows into a new table when SQLite can't alter a constraint.