---
source: prqlc/prqlc/tests/integration/queries.rs
expression: "# mssql:test\nfrom tracks\nsort {-bytes}\nselect {\n    name,\n    bin = ((album_id | as REAL) * 99)\n}\ntake 20\n"
input_file: prqlc/prqlc/tests/integration/queries/cast.prql
snapshot_kind: text
---
frames:
- - 1:25-38
  - columns:
    - !All
      input_id: 124
      except: []
    inputs:
    - id: 124
      name: tracks
      table:
      - default_db
      - tracks
- - 1:39-97
  - columns:
    - !Single
      name:
      - tracks
      - name
      target_id: 131
      target_name: null
    - !Single
      name:
      - bin
      target_id: 132
      target_name: null
    inputs:
    - id: 124
      name: tracks
      table:
      - default_db
      - tracks
- - 1:98-105
  - columns:
    - !Single
      name:
      - tracks
      - name
      target_id: 131
      target_name: null
    - !Single
      name:
      - bin
      target_id: 132
      target_name: null
    inputs:
    - id: 124
      name: tracks
      table:
      - default_db
      - tracks
nodes:
- id: 124
  kind: Ident
  span: 1:13-24
  ident: !Ident
  - default_db
  - tracks
  parent: 130
- id: 128
  kind: Ident
  span: 1:32-37
  ident: !Ident
  - this
  - tracks
  - bytes
  targets:
  - 124
  parent: 130
- id: 130
  kind: 'TransformCall: Sort'
  span: 1:25-38
  children:
  - 124
  - 128
  parent: 140
- id: 131
  kind: Ident
  span: 1:52-56
  ident: !Ident
  - this
  - tracks
  - name
  targets:
  - 124
  parent: 139
- id: 132
  kind: RqOperator
  span: 1:68-95
  alias: bin
  targets:
  - 134
  - 138
  parent: 139
- id: 134
  kind: RqOperator
  span: 1:81-88
  targets:
  - 137
- id: 137
  kind: Ident
  span: 1:70-78
  ident: !Ident
  - this
  - tracks
  - album_id
  targets:
  - 124
- id: 138
  kind: Literal
  span: 1:92-94
- id: 139
  kind: Tuple
  span: 1:46-97
  children:
  - 131
  - 132
  parent: 140
- id: 140
  kind: 'TransformCall: Select'
  span: 1:39-97
  children:
  - 130
  - 139
  parent: 142
- id: 142
  kind: 'TransformCall: Take'
  span: 1:98-105
  children:
  - 140
  - 143
- id: 143
  kind: Literal
  parent: 142
ast:
  name: Project
  stmts:
  - VarDef:
      kind: Main
      name: main
      value:
        Pipeline:
          exprs:
          - FuncCall:
              name:
                Ident: from
                span: 1:13-17
              args:
              - Ident: tracks
                span: 1:18-24
            span: 1:13-24
          - FuncCall:
              name:
                Ident: sort
                span: 1:25-29
              args:
              - Tuple:
                - Unary:
                    op: Neg
                    expr:
                      Ident: bytes
                      span: 1:32-37
                  span: 1:31-37
                span: 1:30-38
            span: 1:25-38
          - FuncCall:
              name:
                Ident: select
                span: 1:39-45
              args:
              - Tuple:
                - Ident: name
                  span: 1:52-56
                - Binary:
                    left:
                      Pipeline:
                        exprs:
                        - Ident: album_id
                          span: 1:70-78
                        - FuncCall:
                            name:
                              Ident: as
                              span: 1:81-83
                            args:
                            - Ident: REAL
                              span: 1:84-88
                          span: 1:81-88
                      span: 1:70-88
                    op: Mul
                    right:
                      Literal:
                        Integer: 99
                      span: 1:92-94
                  span: 1:68-95
                  alias: bin
                span: 1:46-97
            span: 1:39-97
          - FuncCall:
              name:
                Ident: take
                span: 1:98-102
              args:
              - Literal:
                  Integer: 20
                span: 1:103-105
            span: 1:98-105
        span: 1:13-105
    span: 1:0-105