Feature request: support write-only arguments for database user passwords

[evakkuri]

Everybody needs to manage quite a lot of passwords e.g. for database operation, and it's not nice to have all of these in Terraform state files.

Terraform nowadays supports scrubbing these via write-only arguments and ephemeral values and resources.

Would be awesome to get support for these!

[kangasta]

Seems that adding a write-only variant of the password would be quite simple task as we should be able to copy most of the logic from current password field and just add _wo suffix and WriteOnly: true for the write-only variant. However, I think that our API would anyway return the password value, so it would be retrievable even if it is not stored in the state. This is not a blocker for adding the write-only password field, but this would be good to note in the description. 🤔