[Feature Request]: Beam - add AvroIO support to avro transform

### What would you like to happen?

Investigate if it is worth the effort to add a handler

### Issue Priority

Priority: 3

### Issue Component

Component: Beam

Start by investigating the Beam component and its avro transform, focusing on how AvroIO support would fit. Determine whether adding an AvroIO handler is worthwhile and document the resulting scope or recommendation; the issue does not name files, tests, or a specific entry point.

Written by the indexing model from the issue text.