Add support for service app passwords

[benesch]

🚨 DO NOT RELEASE UNTIL 20 JUNE 2024. 🚨

Fix #575.

[benesch]

Amazing—thanks, @bobbyiliev! We should hold off on including this into a release until 20 June 2024 (when the database side changes will go out). But would love your help having all the tests fixed up now, so that we're ready to go in two weeks.

[benesch]

Hell yes! Thanks so much, @bobbyiliev. If you want to do some testing against a real personal stack that supports this new feature:

terraform {
  required_providers {
    materialize = {
      source  = "materialize.com/devex/materialize"
      version = "0.1"
    }
  }
}

# Configuration-based authentication
provider "materialize" {
  endpoint = "https://admin.benesch.dev.cloud.materialize.com"
  cloud_endpoint = "https://api.benesch.dev.cloud.materialize.com"
  base_endpoint = "https://dev.cloud.materialize.com"
  password       = "<sign up at https://benesch.dev.console.materialize.com/>"
  default_region = "aws/us-east-1"
}

resource "materialize_app_password" "example_app_password" {
  name = "example_app_password_name"
  type = "service"
  user = "test"
  roles = ["Member"]
}