Android Room Database Query是否支持row_number？

@Dao
public interface MyDao {
    @Query("SELECT *, (SELECT COUNT(*) FROM your_table WHERE your_table.id <= t.id) AS row_number FROM your_table AS t")
    List<YourEntity> getEntitiesWithRowNumber();
}

@Database(entities = {YourEntity.class}, version = 1, exportSchema = false)
public abstract class MyDatabase extends RoomDatabase {

    public abstract MyDao myDao();

    public static MyDatabase getInstance(Context context) {
        return Room.databaseBuilder(context.getApplicationContext(), MyDatabase.class, "my_database")
                .addCallback(sRoomDatabaseCallback)
                .build();
    }

    private static final RoomDatabase.Callback sRoomDatabaseCallback = new RoomDatabase.Callback() {
        @Override
        public void onCreate(@NonNull SupportSQLiteDatabase db) {
            super.onCreate(db);
            db.execSQL("CREATE FUNCTION IF NOT EXISTS row_number() ..."); // 实现row_number()的逻辑
        }
    };
}

MyDatabase database = MyDatabase.getInstance(context);
List<YourEntity> entities = database.myDao().getEntitiesWithRowNumber();