When tables have the exact same schema, there is an optimization that SQLite does to speed up INSERT. https://github.com/sqlite/sqlite/blob/master/src/insert.c#L3009