Can't reference capitalized types in export to Postgresql

[jason-curtis]

Problem

If there is an enum with capital letters in its name, the .sql export is broken such that the enum can't be referenced (or else I haven't been able to figure out how).

Example

Take an example DBML file:

Enum UserRole{
  "Super Admin"
  "Super Ultra Admin"
}

Table User {
  role UserRole
  ...
}

When I convert that to Postgresql, it looks like:

CREATE TYPE "UserRole" AS ENUM (
  'Super Admin',
  'Super Duper Admin'
);

CREATE TABLE "User" (
  "role" UserRole
)

This seems fine except that SQL loves to ignore capitalization, so upon running the .sql I get ERROR: type "userrole" does not exist. The correct .sql output would have the enum type quoted to reference it correctly:

CREATE TABLE "User" (
  "role" "UserRole"
  ...
)

Attempted workaround

If you use quotes in the DBML like so, you might expect those quotes to carry through to the .sql file:

Table User {
  role "UserRole"
  ...
}

but the above DBML generates the same unquoted SQL, causing the same problem as earlier.

Apologies for the edge case!

[gguy0406]

This doesn't work with normalized enum name as well. In my case, the dbml look like this:

Enum user.gender {
  ...
}

Table user.user {
  ...
  gender user.gender [not null]
}

And the exported PostgreSQL as follow:

CREATE TABLE "user"."user" (
  ...
  "gender" user.gender NOT NULL,
)

which output syntax error at or near "user"