Feat: Add Kyselify for View

[smhmayboudi]

You can add

import type { ColumnBaseConfig, ColumnDataType } from "drizzle-orm";
import { MySqlColumn } from "drizzle-orm/mysql-core";

export type KyselifyView<
  T extends {
    _: {
      selectedFields: Record<
        string,
        MySqlColumn<ColumnBaseConfig<ColumnDataType, string>, object>
      >;
    };
  },
> = {
  [K in keyof T["_"]["selectedFields"]]: T["_"]["selectedFields"][K] extends MySqlColumn<
    infer U,
    object
  >
    ? U extends { data: infer D }
      ? D
      : never
    : never;
};

Usage:

export const pocView = mysqlView("poc_view", {
  id: int("id").default(0).notNull(),
}).existing();
// .as(sql`SELECT id FROM poc_view`);

export interface Database {
  acknowledge: KyselifyView<typeof pocView>;
}

[smhmayboudi]

import type { Column } from "drizzle-orm";

export type KyselifyView<
  T extends {
    _: {
      selectedFields: Record<string, Column>;
    };
  },
> = {
  [K in keyof T["_"]["selectedFields"] &
    string]: T["_"]["selectedFields"][K] extends Column<infer U, object>
    ? U extends { data: infer D }
      ? D
      : never
    : never;
};