Re:The lack of proper “alter table” support in SQLite
by stevoski on Sunday June 16, 2013 @11:21AM
(#5888712)
The H2 open source java database implements "alter table" exactly as per the description of sql alchemy: create a new table with the new structure, copy all the data across, delete the original table, rename the new table to the origina name.
This could perhaps be acceptable for sqlite.