Singular Flag Does Not Affect Enum or Column Names

[omtodkar]

I am using Kysely's code generation tool for a PostgreSQL database. The database contains an enum type for statuses, and I am trying to generate TypeScript types using the --singular flag.

However, when I use the --singular flag, the tool correctly generates table names in singular form (e.g., user instead of users). Unfortunately, it does not generate enum or column names in singular form. These remain in their plural form (e.g., statuses instead of status).

Actual sample ts file:

export type Statuses = "ACTIVE" | "INACTIVE";

export interface User {
  // ... other fields.
  Statuses: Generated<Statuses>;
  userId: Generated<string>;
}

Steps to Reproduce:

1. Have a PostgreSQL database with an enum type (e.g., statuses).
2. Use enum type in a table with similar singular name (e.g. status).

CREATE TYPE statuses AS ENUM ('ACTIVE', 'INACTIVE');

CREATE TABLE IF NOT EXISTS users (
    user_id bigserial PRIMARY KEY,
    name text,
    status statuses DEFAULT 'ACTIVE' NOT NULL
);

3. Run the kysely-codegen command with the --singular flag:

npx kysely-codegen --singular --dialect=postgres --url="<DATABASE_URL>" --out-file="./types.ts"

4. Observe that:

• Table names are generated in singular form.
• enum and column names still remain in plural form.

Expected Behavior:

The --singular flag should apply to all generated types, including enum and column names, ensuring consistency in the naming convention across the generated code.

Actual Behavior:

Only the table names are converted to singular form, while enum and column names remain in plural form.

Kysely Versions:

kysely: 0.27.4
kysely-codegen: 0.17.0

Upvote & Fund

• We're using Polar.sh so you can upvote and help fund this issue.
• We receive the funding once the issue is completed & confirmed by you.
• Thank you in advance for helping prioritize & fund our backlog.