Unable to use boolean and number types if it has Generated<Boolean>

[noudadrichem]

Tbh; I'm not sure if this is a bug or not. But I'm seeing these errors through my codebase. The type is correct as its a boolean or number in the DB and the Generated<> is correct as well.

But when passing a Boolean or Number it keeps erroring out.

How do I properly use these types?

For context. I'm calling .find() like so:

async function find(criteria: Partial<ActionDeployment>) {
    let query = this.db.selectFrom(this.tableName);

    if (criteria.id) {
        query = query.where("id", "=", Number(criteria.id));
    }
}

with the generated types:

export type Generated<T> = T extends ColumnType<infer S, infer I, infer U>
  ? ColumnType<S, I | undefined, U>
  : ColumnType<T, T | undefined, T>;

export type Json = JsonValue;

export type JsonArray = JsonValue[];

export type JsonObject = {
  [x: string]: JsonValue | undefined;
};

export type JsonPrimitive = boolean | number | string | null;

export type JsonValue = JsonArray | JsonObject | JsonPrimitive;

export type Numeric = ColumnType<string, number | string, number | string>;

export type Timestamp = ColumnType<Date, Date | string, Date | string>;

export interface ActionDeployment {
  id: Generated<number>;
  isPublic: Generated<boolean>;
}

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.