SQL generate error?

[hiscaler]

  $orderSource = $this->orm->getSource(Order::class);
  $storeSource = $this->orm->getSource(Store::class);
  $items = $orderSource
      ->getDatabase()
      ->select(['order.store_id', 'store.team_id', "COUNT(*) AS count"])
      ->from($orderSource->getTable() . ' AS order')
      ->leftJoin($storeSource->getTable(), 'store')->on('order.store_id', 'store.id')
      ->groupBy('team_id')
      ->groupBy('store_id')
      ->sqlStatement();

generate sql is

SELECT `order`.`store_id`, `store`.`team_id`, `COUNT(*)` AS `count`
FROM `tong_tool_order` AS `order` 
LEFT JOIN `tong_tool_store` AS `store`
    ON `order`.`store_id` = `store`.`id`  
GROUP BY `team_id`, `store_id` 

COUNT(*) is error, not quote it

[roxblnfk]

https://cycle-orm.dev/docs/database-query-builders/current#sql-fragments-and-expressions

---

Looks like documentation about $select = $db->table('test')->select(['COUNT(*)']); is wrong. Need to check it.

[hiscaler]

Thank you.

Use Fragment is worked, but "count" is not quote

like this

SELECT `order`.`store_id`, `store`.`team_id`, COUNT(*) AS count ....