René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"[BUG] JSQLParser 5.4-SNAPSHOT : PostgreSQL : GROUPS not supported in window function frame clause","articleBody":"  **Failing SQL Feature**\n\n  PostgreSQL `GROUPS` frame mode used inside a window function's frame specification.\n\n  PostgreSQL supports three `frame_mode` options on window function frames: `RANGE`, `ROWS`, and `GROUPS`. The `GROUPS` mode (added in PostgreSQL 11) defines the frame in terms of *peer groups* — sets of rows that are equivalent according to\n  the window's `ORDER BY` clause — rather than individual rows or value ranges. It is valid SQL-standard syntax in PostgreSQL and appears in analytical queries that need to aggregate over a fixed number of distinct ordered groups.\n\n  See the PostgreSQL docs for details: https://www.postgresql.org/docs/current/sql-expressions.html#SYNTAX-WINDOW-FUNCTIONS\n\n  **SQL Example**\n\n  ```sql\n  CREATE TABLE events (\n      id SERIAL PRIMARY KEY,\n      user_id INT,\n      ts INT,\n      value INT\n  );\n\n  INSERT INTO events (user_id, ts, value) VALUES\n  (1, 1, 10),\n  (1, 1, 20),\n  (1, 2, 30),\n  (1, 3, 40),\n  (1, 3, 50),\n  (1, 4, 60);\n\n  SELECT\n      id,\n      ts,\n      value,\n      SUM(value) OVER (\n          ORDER BY ts\n          GROUPS BETWEEN 1 PRECEDING AND CURRENT ROW\n      ) AS sum_last_2_groups\n  FROM events\n  ORDER BY ts, id;\n  ```\n  \n  **Parsing error**\n\n  `ParseException: Encountered: \u003cS_IDENTIFIER\u003e / \"GROUPS\", at line 7, column 9, in lexical state DEFAULT.`\n","author":{"url":"https://github.com/tomershay","@type":"Person","name":"tomershay"},"datePublished":"2026-05-12T17:30:09.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/2431/JSqlParser/issues/2431"}