SQLite did get support for renaming columns recently [1]. Anyways, the process you describe is also used in MySQL for doing online schema migrations. [2] "prop

SQLite did get support for renaming columns recently [1]. Anyways, the process you describe is also used in MySQL for doing online schema migrations. [2] "proper" database migrations cause downtime [1]: https://stackoverflow.com/questions/805363/how-do-i-rename-a-column-in-a-sqlite-database-table https://stackoverflow.com/questions/805363/how-do-i-rename-a... [2]: https://github.com/github/gh-ost https://github.com/github/gh-ost