Добавлены оконные (аналитические) функции, "по образу и подобию" PGSQL:Window function support was added to SQLite with release version 3.25.0 (2018-09-15) .
The SQLite developers used the PostgreSQL window function documentation as their primary reference for how window functions ought to behave.