[Epic] A Collection of AVRO related tickets

DataFusion can read avro files. For example see https://github.com/apache/datafusion/blob/main/datafusion/sqllogictest/test_files/avro.slt

```sql
CREATE EXTERNAL TABLE single_nan (
mycol FLOAT
)
STORED AS AVRO
LOCATION '../../testing/data/avro/single_nan.avro';
```

Here is a collection of items to improve the
- [ ] https://github.com/apache/datafusion/issues/11342
- [x] https://github.com/apache/datafusion/issues/14097

Start with the existing AVRO example in datafusion/sqllogictest/test_files/avro.slt and review the remaining linked ticket, issue 11342. Determine the concrete AVRO improvements still required and use the checklist to define when the epic is complete.

Written by the indexing model from the issue text.