GROUP BY

## Is there a way to group?

How to use GROUP BY_?
I expected to get result of ...
```sql
SELECT *
FROM `travel-sample`
GROUP BY id;
ORDER BY id asc;
```
I have tried ...

```javascript
const results = database.query({
  select: [], // Leave empty to query for all
  group: [{ property: 'id' } ],
  order: [{ property: 'id ', direction: 'asc' }]
});
```