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`)

Start by locating the documentation for the Table API and Transaction API write support. Compare the existing coverage of append, overwrite, and delete, including parameters such as overwrite_filter, and document each operation and API mode in separate subsections with the missing details filled in.

Written by the indexing model from the issue text.