如何在编译期间修复Android Studio中Room中复杂SQL语句的验证错误？

我目前有一个DAO查询语句的sql语句：

    @Query(
            "select " +
            "    avg(q1.weight) over (rows between 3 PRECEDING AND CURRENT ROW) as adjusted_weight " +
            "from weight_record AS q1 " +
            "order by q1.date"
    )
    LiveData<List<AggregatedWeightRecord>> getAggregatedRecords();

当我直接在sqlite3内尝试此查询时，它可以正常工作。当我将其放入Android Studio并尝试进行编译时，出现此错误：

error: extraneous input '(' expecting {<EOF>, ';', K_ALTER, K_ANALYZE, K_ATTACH, K_BEGIN, K_COMMIT, K_CREATE, K_DELETE, K_DETACH, K_DROP, K_END, K_EXPLAIN, K_INSERT, K_PRAGMA, K_REINDEX, K_RELEASE, K_REPLACE, K_ROLLBACK, K_SAVEPOINT, K_SELECT, K_UPDATE, K_VACUUM, K_VALUES, K_WITH, UNEXPECTED_CHAR}

extraneous input ')' expecting {<EOF>, ';', K_ALTER, K_ANALYZE, K_ATTACH, K_BEGIN, K_COMMIT, K_CREATE, K_DELETE, K_DETACH, K_DROP, K_END, K_EXPLAIN, K_INSERT, K_PRAGMA, K_REINDEX, K_RELEASE, K_REPLACE, K_ROLLBACK, K_SAVEPOINT, K_SELECT, K_UPDATE, K_VACUUM, K_VALUES, K_WITH, UNEXPECTED_CHAR}

我试图更改查询，但现在需要使用Windows。我还在@Query之前添加了@SkipQueryVerification，但仍然收到错误。

我有什么选择可以编译并同时具有LiveData功能？