Conditional schema for different database types

[duarten]

Hi,

I want to reuse the same schema.hcl for a local sqlite database and for a prod mysql database; in the config file, there's corresponding "local" and "prod" envs. I'd like to adapt some column types depending on the env. I wanted to do something like:

variable "id_key_type" {
  type = string
  description = "The name of the tenant (schema) to create"
}

table "foo" {
  schema = schema.main
  column "id" {
    type = var.id_key_type
    auto_increment = true
  }
}

But it doesn't seem like I can access variables when specifying a column type?