Provided Androidx Paging3 example for keyed queries does not compile on 3.35 SQLite dialect

[mainrs]

I get the following error message with these two queries. Any idea what might be wrong here?

keyedQuery:
SELECT * FROM songs
WHERE id >= :beginInclusive AND (id < :endExclusive OR :endExclusive IS NULL)
ORDER BY id ASC;

pageBoundaries:
SELECT id
FROM (
  SELECT
    id,
    CASE
      WHEN ((row_number() OVER(ORDER BY id ASC) - 0) % :limit) = 0 THEN 1
      WHEN id = :anchor THEN 1
      ELSE 0
    END page_boundary;
  FROM songs
  ORDER BY id ASC
)
WHERE page_boundary = 1;

Task :server:database:generateMainDatabaseInterface FAILED

Compiling with dialect app.cash.sqldelight.dialects.sqlite_3_35.SqliteDialect

/server/database/src/main/sqldelight/server/database/Song.sq: (27, 31): ')' or <expr> expected, got 'ORDER'
22    SELECT id
23    FROM (
24      SELECT
25        id,
26        CASE
27          WHEN ((row_number() OVER(ORDER BY id ASC) - 0) % :limit) = 0 THEN 1
                                     ^^^^^
28          WHEN id = :anchor THEN 1
29          ELSE 0
30        END page_boundary


Execution failed for task ':server:database:generateMainDatabaseInterface'.
> A failure occurred while executing app.cash.sqldelight.gradle.SqlDelightTask$GenerateInterfaces
   > Generation failed; see the generator error output for details.

* Try:
> Run with --stacktrace option to get the stack trace.
> Run with --info or --debug option to get more log output.
> Run with --scan to get full insights.
> Get more help at https://help.gradle.org.
Deprecated Gradle features were used in this build, making it incompatible with Gradle 9.0.
You can use '--warning-mode all' to show the individual deprecation warnings and determine if they come from your own scripts or plugins.
For more on this, please refer to https://docs.gradle.org/8.4/userguide/command_line_interface.html#sec:command_line_warnings in the Gradle documentation.
BUILD FAILED in 3s
26 actionable tasks: 2 executed, 24 up-to-date