如何在android房间库中使用sql视图

CREATE VIEW my_view AS
SELECT table1.column1, table2.column2
FROM table1
JOIN table2 ON table1.id = table2.id;

@DatabaseView(viewName = "my_view",
        value = "SELECT table1.column1, table2.column2 " +
                "FROM table1 " +
                "JOIN table2 ON table1.id = table2.id")
public class MyView {
    public String column1;
    public String column2;
}

@Database(entities = {Table1.class, Table2.class}, views = {MyView.class}, version = 1)
public abstract class AppDatabase extends RoomDatabase {
    // ...
}

@Dao
public interface MyViewDao {
    @Query("SELECT * FROM my_view")
    List<MyView> getAllData();
}