---
source: prqlc/prqlc/tests/integration/queries.rs
expression: "# mysql:skip\n# clickhouse:skip\n# glaredb:skip (the string_agg function is not supported)\nfrom tracks\nfilter genre_id == 100\nderive empty_name = name == ''\naggregate {sum track_id, concat_array name, all empty_name, any empty_name}\n"
input_file: prqlc/prqlc/tests/integration/queries/aggregation.prql
snapshot_kind: text
---
frames:
- - 1:101-123
  - columns:
    - !All
      input_id: 124
      except: []
    inputs:
    - id: 124
      name: tracks
      table:
      - default_db
      - tracks
- - 1:124-154
  - columns:
    - !All
      input_id: 124
      except: []
    - !Single
      name:
      - empty_name
      target_id: 131
      target_name: null
    inputs:
    - id: 124
      name: tracks
      table:
      - default_db
      - tracks
- - 1:155-230
  - columns:
    - !Single
      name: null
      target_id: 137
      target_name: null
    - !Single
      name: null
      target_id: 140
      target_name: null
    - !Single
      name: null
      target_id: 143
      target_name: null
    - !Single
      name: null
      target_id: 146
      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: 130
- id: 126
  kind: RqOperator
  span: 1:108-123
  targets:
  - 128
  - 129
  parent: 130
- id: 128
  kind: Ident
  span: 1:108-116
  ident: !Ident
  - this
  - tracks
  - genre_id
  targets:
  - 124
- id: 129
  kind: Literal
  span: 1:120-123
- id: 130
  kind: 'TransformCall: Filter'
  span: 1:101-123
  children:
  - 124
  - 126
  parent: 136
- id: 131
  kind: RqOperator
  span: 1:144-154
  alias: empty_name
  targets:
  - 133
  - 134
  parent: 135
- id: 133
  kind: Ident
  span: 1:144-148
  ident: !Ident
  - this
  - tracks
  - name
  targets:
  - 124
- id: 134
  kind: Literal
  span: 1:152-154
- id: 135
  kind: Tuple
  span: 1:144-154
  children:
  - 131
  parent: 136
- id: 136
  kind: 'TransformCall: Derive'
  span: 1:124-154
  children:
  - 130
  - 135
  parent: 150
- id: 137
  kind: RqOperator
  span: 1:166-178
  targets:
  - 139
  parent: 149
- id: 139
  kind: Ident
  span: 1:170-178
  ident: !Ident
  - this
  - tracks
  - track_id
  targets:
  - 124
- id: 140
  kind: RqOperator
  span: 1:180-197
  targets:
  - 142
  parent: 149
- id: 142
  kind: Ident
  span: 1:193-197
  ident: !Ident
  - this
  - tracks
  - name
  targets:
  - 124
- id: 143
  kind: RqOperator
  span: 1:199-213
  targets:
  - 145
  parent: 149
- id: 145
  kind: Ident
  span: 1:203-213
  ident: !Ident
  - this
  - empty_name
  targets:
  - 131
- id: 146
  kind: RqOperator
  span: 1:215-229
  targets:
  - 148
  parent: 149
- id: 148
  kind: Ident
  span: 1:219-229
  ident: !Ident
  - this
  - empty_name
  targets:
  - 131
- id: 149
  kind: Tuple
  span: 1:165-230
  children:
  - 137
  - 140
  - 143
  - 146
  parent: 150
- id: 150
  kind: 'TransformCall: Aggregate'
  span: 1:155-230
  children:
  - 136
  - 149
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: filter
                span: 1:101-107
              args:
              - Binary:
                  left:
                    Ident: genre_id
                    span: 1:108-116
                  op: Eq
                  right:
                    Literal:
                      Integer: 100
                    span: 1:120-123
                span: 1:108-123
            span: 1:101-123
          - FuncCall:
              name:
                Ident: derive
                span: 1:124-130
              args:
              - Binary:
                  left:
                    Ident: name
                    span: 1:144-148
                  op: Eq
                  right:
                    Literal:
                      String: ''
                    span: 1:152-154
                span: 1:144-154
                alias: empty_name
            span: 1:124-154
          - FuncCall:
              name:
                Ident: aggregate
                span: 1:155-164
              args:
              - Tuple:
                - FuncCall:
                    name:
                      Ident: sum
                      span: 1:166-169
                    args:
                    - Ident: track_id
                      span: 1:170-178
                  span: 1:166-178
                - FuncCall:
                    name:
                      Ident: concat_array
                      span: 1:180-192
                    args:
                    - Ident: name
                      span: 1:193-197
                  span: 1:180-197
                - FuncCall:
                    name:
                      Ident: all
                      span: 1:199-202
                    args:
                    - Ident: empty_name
                      span: 1:203-213
                  span: 1:199-213
                - FuncCall:
                    name:
                      Ident: any
                      span: 1:215-218
                    args:
                    - Ident: empty_name
                      span: 1:219-229
                  span: 1:215-229
                span: 1:165-230
            span: 1:155-230
        span: 1:89-230
    span: 1:0-230