Query fails with comment at the end in Clickhouse

## Bug Description

Trying to execute this query fails in Clickhouse:

```
select * from numbers(10);
-- This is a comment
```

The error is:

Syntax error (Multi-statements are not allowed): failed at position 26 (end of query) (line 1, col 26): ;
-- This is a comment 
FORMAT JSONCompactEachRowWithNamesAndTypes. . 