add support for passing in a `database` (formerly workspace_database), `search_path`, and `search_path_prefix` to child mods in the mod definition.

[kaidaguerre]

e want to add support for passing in a database (formerly workspace_database), search_path, and search_path_prefix to child mods in the mod definition. By default, they inherit the active database but can be overridden in the require block:

variable "duckdb_connection_string" {
  default = "duckdb:/home/ducks/mallard.db"
}

variable "flowpipe_connection_string" {
  default = "sqlite:/./my_mod/flowpipe.db"
}

mod "local" {
  require {
    mod "github.com/turbot/my_duckdb_mod {
      version     = ">=0.66.0"
      database    = var.duckdb_connection_string
      args = {
        foo = "bar"
      }
    }

    mod "github.com/turbot/flowpipe {
      version   = ">=0.66.0"
      database  = var.flowpipe_connection_string,
    }

    mod "github.com/turbot/aws_compliance {
      version            = ">=0.66.0"
      search_path_prefix = "aws_01"

    }
  }
}

[kaidaguerre]

implemented in 164a87907d9a3f846d508f86a9b6eb368238dbc9