DOCS: Improve Documentation on Write Support

### Feature Request / Improvement

We currently have Write support through two modes:
1. through the Table API
2. through the Transaction API

We also have support for different modes of writes like:
1. append
2. overwrite
3. delete

Which make use of different arg parameters.

It would be great to update our docs to describe each of these operations and API modes explicitly in detail as separate subsections, and pad in any missing details (like the use of `overwrite_filter` in `overwrite`)