René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"[FEATURE] Add support for MATCH_RECOGNIZE clause (BigQuery) to JSQLParser","articleBody":"### Grammar or Syntax Description\n- JSQLParser version tested: 5.4-SNAPSHOT. The query above throws `\u003e Encountered: \u003cK_BY\u003e / \"BY\", at line 14, column 12, in lexical state DEFAULT.`  \n-  Error encountred using [Starlake.ai | SQL PLayground](https://labs.starlake.ai/) on DuckDB Transpiller tab. \n- BigQuery MATCH_RECOGNIZE syntax – https://cloud.google.com/bigquery/docs/match-recognize\n- Blog announcement – https://cloud.google.com/blog/products/data-analytics/introducing-match_recognize-in-bigquery\n\n### SQL Example\n```sql\nWITH Operations AS (\n  SELECT 1 AS OperationID, 120.00 AS Amount, 'C001' AS CatalogID,\n         DATE '2025-01-03' AS OperationDate UNION ALL\n  SELECT 2, 20.00, 'C001', DATE '2025-01-04' UNION ALL\n  SELECT 3, 175.00, 'C001', DATE '2025-01-05' UNION ALL\n  SELECT 4,  30.00, 'C001', DATE '2025-01-10' UNION ALL\n  SELECT 5, 190.00, 'C001', DATE '2025-01-11' UNION ALL\n  SELECT 6, 250.00, 'C001', DATE '2025-01-12'\n)\n\nSELECT *\nFROM Operations\nMATCH_RECOGNIZE (\n  PARTITION BY CatalogID\n  ORDER BY OperationDate ASC\n  MEASURES\n    FIRST(OperationDate) AS START_DT,\n    LAST(OperationDate)  AS END_DT,\n    SUM(Amount)          AS TOTAL_AMOUNT,\n    COUNT(*)             AS ROW_COUNT\n  AFTER MATCH SKIP  PAST LAST ROW   \n  PATTERN (low mid+ high+)                      \n  DEFINE\n    low AS Amount \u003c 50,\n    mid AS Amount between 100 and 200,\n    high AS Amount \u003e 200\n  OPTIONS ( use_longest_match = FALSE )\n)\nORDER BY CatalogID, START_DT;\n```\nThis query sgould return this result \n\n```\nCatalogID\tSTART_DT\tEND_DT\t         TOTAL_AMOUNT\t ROW_COUNT\nC001\t        2025-01-10\t2025-01-12\t  470.0\t                 3\n```\n\n\n\n\nThank you for considering this feature.","author":{"url":"https://github.com/zedach","@type":"Person","name":"zedach"},"datePublished":"2025-11-27T21:36:51.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":1},"url":"https://github.com/2350/JSqlParser/issues/2350"}