Comet writer doesnt support `INSERT OVERWRITE`

### Describe the bug

Comet falls back to Spark however it should also understand Spark SQL writes like 

```
INSERT OVERWRITE DIRECTORY 'dir'
USING PARQUET
SELECT /*+ REPARTITION(90) */ something
FROM df;
```

### Steps to reproduce

_No response_

### Expected behavior

_No response_

### Additional context

_No response_