Enable entering the password through standard input or by being prompted for it

[stuartpa]

Enable entering the password through standard input or by being prompted for it? sqlcmd users are generally accustomed to the password prompt in interactive mode, and ci/cd pipelines that use Azure CLI can pipe a password to az devops login directly using stdin. We could offer both models as well.