Shouldn't we rather just forbid group by a constant (i.e. throw an exception)?
It is probably currently also semantically broken in postgres. This does NOT group by constant 1 in postgres, but by the first column mentioned in the SELECT part, sup_id:
```
SELECT 
  sup_id
FROM 
  public."coffees"
GROUP BY 1
```