Comet writer to support nested types

### What is the problem the feature request solves?

Currently Comet writes falls back to Spark for nested types

```
Execute InsertIntoHadoopFsRelationCommand [COMET: Complex types are not supported]
```

### Describe the potential solution

Its potentially safe to enable nested types as it backed by DataFusion parquet writers + including some tests

### Additional context

_No response_