---
source: prqlc/prqlc/tests/integration/queries.rs
expression: tokens
input_file: prqlc/prqlc/tests/integration/queries/window.prql
snapshot_kind: text
---
Tokens(
    [
        0..0: Start,
        0..43: Comment(" clickhouse:skip problems with DISTINCT ON"),
        43..44: NewLine,
        44..181: Comment(" glaredb:skip — TODO: started raising an error on 2024-05-20, from https://github.com/PRQL/prql/actions/runs/9154902656/job/25198160283:"),
        181..182: NewLine,
        186..261: Comment(" ERROR: This feature is not implemented: Unsupported ast node in sqltorel:"),
        261..262: NewLine,
        266..342: Comment(" Substring { expr: Identifier(Ident { value: \"title\", quote_style: None }),"),
        342..343: NewLine,
        347..412: Comment(" substring_from: Some(Value(Number(\"2\", false))), substring_for:"),
        412..413: NewLine,
        417..467: Comment(" Some(Value(Number(\"5\", false))), special: true }"),
        467..468: NewLine,
        468..472: Ident("from"),
        473..479: Ident("tracks"),
        479..480: NewLine,
        480..485: Ident("group"),
        486..494: Ident("genre_id"),
        495..496: Control('('),
        496..497: NewLine,
        499..503: Ident("sort"),
        504..516: Ident("milliseconds"),
        516..517: NewLine,
        519..525: Ident("derive"),
        526..527: Control('{'),
        527..528: NewLine,
        532..535: Ident("num"),
        536..537: Control('='),
        538..548: Ident("row_number"),
        549..553: Ident("this"),
        553..554: Control(','),
        554..555: NewLine,
        559..564: Ident("total"),
        565..566: Control('='),
        567..572: Ident("count"),
        573..577: Ident("this"),
        577..578: Control(','),
        578..579: NewLine,
        583..591: Ident("last_val"),
        592..593: Control('='),
        594..598: Ident("last"),
        599..607: Ident("track_id"),
        607..608: Control(','),
        608..609: NewLine,
        611..612: Control('}'),
        612..613: NewLine,
        615..619: Ident("take"),
        620..622: Literal(Integer(10)),
        622..623: NewLine,
        623..624: Control(')'),
        624..625: NewLine,
        625..629: Ident("sort"),
        630..631: Control('{'),
        631..639: Ident("genre_id"),
        639..640: Control(','),
        641..653: Ident("milliseconds"),
        653..654: Control('}'),
        654..655: NewLine,
        655..661: Ident("select"),
        662..663: Control('{'),
        663..671: Ident("track_id"),
        671..672: Control(','),
        673..681: Ident("genre_id"),
        681..682: Control(','),
        683..686: Ident("num"),
        686..687: Control(','),
        688..693: Ident("total"),
        693..694: Control(','),
        695..703: Ident("last_val"),
        703..704: Control('}'),
        704..705: NewLine,
        705..711: Ident("filter"),
        712..720: Ident("genre_id"),
        721..723: Gte,
        724..726: Literal(Integer(22)),
        726..727: NewLine,
    ],
)