Document in YAML whether discoverable loaders append or upsert (or both)

So that users will know whether meltano#2504 (closed) applies.

We'll have to think about how to represent this in the YAML. Could be under capabilities or another generic key. Would prefer not to diverge tap/target specs.