我尝试使用room进行迁移并重命名列名。
以下是我目前为止的代码：

private val MIGRATION_FROM_3_TO_4 = {
    object : Migration(3, 4) {
        override fun migrate(database: SupportSQLiteDatabase) {
            database.execSQL("ALTER TABLE Contacts RENAME Name TO contact_name")
            database.execSQL("ALTER TABLE People RENAME Name TO person_name")
        }
    }
}

输出：

android.database.sqlite.SQLiteException: near "Name": syntax error (code 1): , while compiling: ALTER TABLE Contacts RENAME Name TO contact_name.