[Bug] Single "count" aggregation fails

[YaroShkvorets]

Bug report

If I have a single "count" aggregation:

type Block @entity(timeseries: true) {
  id: Int8!
  timestamp: Timestamp!
  hash: Bytes!
  number: Int!
}

type Stats @aggregation(intervals: ["hour", "day"], source: "Block") {
  id: Int8!
  timestamp: Timestamp!

  count: Int! @aggregate(fn: "count")
}

graph-node fails with invalid SQL expression error:

postgres-defi    | 2024-09-07 20:45:32.788 UTC [91] ERROR:  syntax error at or near "from" at character 205
postgres-defi    | 2024-09-07 20:45:32.788 UTC [91] STATEMENT:  insert into "sgd1"."stats_hour"(id, timestamp, block$, "count") select max(id) as id, timestamp, $3, count(*) as "count" from (select id, date_bin('3600s', timestamp, 'epoch'::timestamptz) as timestamp,  from "sgd1"."block" where "sgd1"."block".timestamp >= $1 and "sgd1"."block".timestamp < $2 order by "sgd1"."block".timestamp) data group by timestamp

Note "," before "from" that shouldn't be there.

Subgraph example: https://github.com/YaroShkvorets/common-subgraphs/tree/main/aggregation-broken

Relevant log output

No response

IPFS hash

No response

Subgraph name or link to explorer

No response

Some information to help us out

• [ ] Tick this box if this bug is caused by a regression found in the latest release.
• [ ] Tick this box if this bug is specific to the hosted service.
• [X] I have searched the issue tracker to make sure this issue is not a duplicate.

OS information

None

[YaroShkvorets]

PR: https://github.com/graphprotocol/graph-node/pull/5639