---
source: prqlc/prqlc/tests/integration/queries.rs
expression: "# glaredb:skip (May be a bag of String type conversion for Postgres Client)\n# mssql:test\nfrom tracks\nsort milliseconds\nselect display = case [\n    composer != null => composer,\n    genre_id < 17 => 'no composer',\n    true => f'unknown composer'\n]\ntake 10\n"
input_file: prqlc/prqlc/tests/integration/queries/switch.prql
snapshot_kind: text
---
frames:
- - 1:101-118
  - columns:
    - !All
      input_id: 124
      except: []
    inputs:
    - id: 124
      name: tracks
      table:
      - default_db
      - tracks
- - 1:119-246
  - columns:
    - !Single
      name:
      - display
      target_id: 129
      target_name: null
    inputs:
    - id: 124
      name: tracks
      table:
      - default_db
      - tracks
- - 1:247-254
  - columns:
    - !Single
      name:
      - display
      target_id: 129
      target_name: null
    inputs:
    - id: 124
      name: tracks
      table:
      - default_db
      - tracks
nodes:
- id: 124
  kind: Ident
  span: 1:89-100
  ident: !Ident
  - default_db
  - tracks
  parent: 128
- id: 126
  kind: Ident
  span: 1:106-118
  ident: !Ident
  - this
  - tracks
  - milliseconds
  targets:
  - 124
  parent: 128
- id: 128
  kind: 'TransformCall: Sort'
  span: 1:101-118
  children:
  - 124
  - 126
  parent: 143
- id: 129
  kind: Case
  span: 1:136-246
  alias: display
  targets:
  - 130
  - 134
  - 135
  - 139
  - 140
  - 141
  parent: 142
- id: 130
  kind: RqOperator
  span: 1:147-163
  targets:
  - 132
  - 133
- id: 132
  kind: Ident
  span: 1:147-155
  ident: !Ident
  - this
  - tracks
  - composer
  targets:
  - 124
- id: 133
  kind: Literal
  span: 1:159-163
- id: 134
  kind: Ident
  span: 1:167-175
  ident: !Ident
  - this
  - tracks
  - composer
  targets:
  - 124
- id: 135
  kind: RqOperator
  span: 1:181-194
  targets:
  - 137
  - 138
- id: 137
  kind: Ident
  span: 1:181-189
  ident: !Ident
  - this
  - tracks
  - genre_id
  targets:
  - 124
- id: 138
  kind: Literal
  span: 1:192-194
- id: 139
  kind: Literal
  span: 1:198-211
- id: 140
  kind: Literal
  span: 1:217-221
- id: 141
  kind: FString
  span: 1:225-244
- id: 142
  kind: Tuple
  span: 1:136-246
  children:
  - 129
  parent: 143
- id: 143
  kind: 'TransformCall: Select'
  span: 1:119-246
  children:
  - 128
  - 142
  parent: 145
- id: 145
  kind: 'TransformCall: Take'
  span: 1:247-254
  children:
  - 143
  - 146
- id: 146
  kind: Literal
  parent: 145
ast:
  name: Project
  stmts:
  - VarDef:
      kind: Main
      name: main
      value:
        Pipeline:
          exprs:
          - FuncCall:
              name:
                Ident: from
                span: 1:89-93
              args:
              - Ident: tracks
                span: 1:94-100
            span: 1:89-100
          - FuncCall:
              name:
                Ident: sort
                span: 1:101-105
              args:
              - Ident: milliseconds
                span: 1:106-118
            span: 1:101-118
          - FuncCall:
              name:
                Ident: select
                span: 1:119-125
              args:
              - Case:
                - condition:
                    Binary:
                      left:
                        Ident: composer
                        span: 1:147-155
                      op: Ne
                      right:
                        Literal: 'Null'
                        span: 1:159-163
                    span: 1:147-163
                  value:
                    Ident: composer
                    span: 1:167-175
                - condition:
                    Binary:
                      left:
                        Ident: genre_id
                        span: 1:181-189
                      op: Lt
                      right:
                        Literal:
                          Integer: 17
                        span: 1:192-194
                    span: 1:181-194
                  value:
                    Literal:
                      String: no composer
                    span: 1:198-211
                - condition:
                    Literal:
                      Boolean: true
                    span: 1:217-221
                  value:
                    FString:
                    - !String unknown composer
                    span: 1:225-244
                span: 1:136-246
                alias: display
            span: 1:119-246
          - FuncCall:
              name:
                Ident: take
                span: 1:247-251
              args:
              - Literal:
                  Integer: 10
                span: 1:252-254
            span: 1:247-254
        span: 1:89-254
    span: 1:0-254