CREATE TABLE IF NOT EXISTS person(
    id INT NOT NULL,
    birthday DATE NOT NULL
);

CREATE TABLE IF NOT EXISTS person(
    id INT NOT NULL,
    birthday DATE NOT NULL
);

-- both are valid queries
SELECT * FROM person WHERE birthday < '2020-01-01';
SELECT * FROM person WHERE birthday < NOW();

-- both are valid queries
SELECT * FROM person WHERE birthday < '2020-01-01';
SELECT * FROM person WHERE birthday < NOW();

export interface PersonTable {
  id: Generated<number>;
  birthday: ColumnType<Date, Date, Date>;
}

// ❌ will give a type error because birthday is a string
await db.selectFrom('person').where('birthday', '=', '2020-01-01');

export interface PersonTable {
  id: Generated<number>;
  birthday: ColumnType<Date, Date, Date>;
}

// ❌ will give a type error because birthday is a string
await db.selectFrom('person').where('birthday', '=', '2020-01-01');

export interface PersonTable {
  id: Generated<number>;
  birthday: ColumnType<Date | string, Date | string, Date | string>;
}

// ❌ res.birthday will be inferred as Date | string instead of just Date
const res = await db.selectFrom('person').selectAll().executeTakeFirstOrThrow();

export interface PersonTable {
  id: Generated<number>;
  birthday: ColumnType<Date | string, Date | string, Date | string>;
}

// ❌ res.birthday will be inferred as Date | string instead of just Date
const res = await db.selectFrom('person').selectAll().executeTakeFirstOrThrow();

function jsonbAgg<O>(
    expr: Expression<O>,
): RawBuilder<Simplify<O>[]> {
    return sql`jsonb_agg(${expr})`;
}

function jsonbAgg<O>(
    expr: Expression<O>,
): RawBuilder<Simplify<O>[]> {
    return sql`jsonb_agg(${expr})`;
}

interface DifferenceCreate {
    type: "CREATE";
    value: any;
}

interface DifferenceRemove {
    type: "REMOVE";
    oldValue: any;
}

interface DifferenceChange {
    type: "CHANGE";
    value: any;
    oldValue: any;
}

export type Difference = DifferenceCreate | DifferenceRemove | DifferenceChange;

function myFunction(): Difference {
    return { type: 'CREATE', value: 1 }
}

interface DifferenceCreate {
    type: "CREATE";
    value: any;
}

interface DifferenceRemove {
    type: "REMOVE";
    oldValue: any;
}

interface DifferenceChange {
    type: "CHANGE";
    value: any;
    oldValue: any;
}

export type Difference = DifferenceCreate | DifferenceRemove | DifferenceChange;

function myFunction(): Difference {
    return { type: 'CREATE', value: 1 }
}

const test:Difference = await client.test.query();

const test:Difference = await client.test.query();

Type '{ type: "CREATE"; value?: any; } | { type: "REMOVE"; oldValue?: any; } | { type: "CHANGE"; value?: any; oldValue?: any; }' is not assignable to type 'Difference'.
  Type '{ type: "CREATE"; value?: any; }' is not assignable to type 'Difference'.
    Type '{ type: "CREATE"; value?: any; }' is not assignable to type 'DifferenceCreate'.
      Property 'value' is optional in type '{ type: "CREATE"; value?: any; }' but required in type 'DifferenceCreate'.

Type '{ type: "CREATE"; value?: any; } | { type: "REMOVE"; oldValue?: any; } | { type: "CHANGE"; value?: any; oldValue?: any; }' is not assignable to type 'Difference'.
  Type '{ type: "CREATE"; value?: any; }' is not assignable to type 'Difference'.
    Type '{ type: "CREATE"; value?: any; }' is not assignable to type 'DifferenceCreate'.
      Property 'value' is optional in type '{ type: "CREATE"; value?: any; }' but required in type 'DifferenceCreate'.

class StandingsInteraction {
    public async interaction(interaction: TypedCommands['standings']) {
        // interaction is ChatInputCommandInteraction
        await interaction.deferReply();

        const { data, expired } = await standingsCache.getData();

        if (!expired) {
            return await interaction.editReply({
                content: data // data is a string here
            });
        }

        const res = await interaction.editReply({
            files: [{
                attachment: data, // data is a Buffer here
                name: 'la-liga-standings.png'
            }]
        });

        standingsCache.revalidate(res);
    }
}

class StandingsInteraction {
    public async interaction(interaction: TypedCommands['standings']) {
        // interaction is ChatInputCommandInteraction
        await interaction.deferReply();

        const { data, expired } = await standingsCache.getData();

        if (!expired) {
            return await interaction.editReply({
                content: data // data is a string here
            });
        }

        const res = await interaction.editReply({
            files: [{
                attachment: data, // data is a Buffer here
                name: 'la-liga-standings.png'
            }]
        });

        standingsCache.revalidate(res);
    }
}

DiscordAPIError[10062]: Unknown interaction
    at handleErrors (/home/node_modules/@discordjs/rest/dist/index.js:687:13)
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async BurstHandler.runRequest (/home/node_modules/@discordjs/rest/dist/index.js:786:23)
    at async _REST.request (/home/node_modules/@discordjs/rest/dist/index.js:1218:22)
    at async ChatInputCommandInteraction.deferReply (/home/node_modules/discord.js/src/structures/interfaces/InteractionResponses.js:69:5)
    at async StandingsInteraction.interaction (file:///home/apps/discord/out/commands/standings.js:5:5)
    at async interactionController (file:///home/apps/discord/out/commands/_controller.js:31:7)
    at async Client.<anonymous> (file:///home/apps/discord/out/index.js:13:5) {
  requestBody: { files: undefined, json: { type: 5, data: [Object] } },
  rawError: { message: 'Unknown interaction', code: 10062 },
  code: 10062,
  status: 404,
  method: 'POST',
  url: 'https://discord.com/api/v10/interactions/.../callback'
}

DiscordAPIError[10062]: Unknown interaction
    at handleErrors (/home/node_modules/@discordjs/rest/dist/index.js:687:13)
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async BurstHandler.runRequest (/home/node_modules/@discordjs/rest/dist/index.js:786:23)
    at async _REST.request (/home/node_modules/@discordjs/rest/dist/index.js:1218:22)
    at async ChatInputCommandInteraction.deferReply (/home/node_modules/discord.js/src/structures/interfaces/InteractionResponses.js:69:5)
    at async StandingsInteraction.interaction (file:///home/apps/discord/out/commands/standings.js:5:5)
    at async interactionController (file:///home/apps/discord/out/commands/_controller.js:31:7)
    at async Client.<anonymous> (file:///home/apps/discord/out/index.js:13:5) {
  requestBody: { files: undefined, json: { type: 5, data: [Object] } },
  rawError: { message: 'Unknown interaction', code: 10062 },
  code: 10062,
  status: 404,
  method: 'POST',
  url: 'https://discord.com/api/v10/interactions/.../callback'
}

import { sql } from 'kysely';

async function materializedQuery() {
    // this func never gets called, just using it to create a type
    return await db.selectFrom('countries').selectAll().execute();
}

async function materializedView() {
    return await sql`select * from my_materialized_view`.execute(db) as unknown as ReturnType<typeof materializedQuery>;
}

/** 
    function materializedView(): Promise<{
        id: number;
        name: string;
    }[]>
 */

import { sql } from 'kysely';

async function materializedQuery() {
    // this func never gets called, just using it to create a type
    return await db.selectFrom('countries').selectAll().execute();
}

async function materializedView() {
    return await sql`select * from my_materialized_view`.execute(db) as unknown as ReturnType<typeof materializedQuery>;
}

/** 
    function materializedView(): Promise<{
        id: number;
        name: string;
    }[]>
 */

SELECT
  "users"."id",
  COUNT(*) FILTER (
    WHERE
      "predictions"."userId" = "users.id"
  ) AS "apperances"
FROM
  "users"
  INNER JOIN "predictions" ON "predictions"."userId" = "users"."id"
  INNER JOIN "matches" ON "matchId" = "predictions"."matchId"

SELECT
  "users"."id",
  COUNT(*) FILTER (
    WHERE
      "predictions"."userId" = "users.id"
  ) AS "apperances"
FROM
  "users"
  INNER JOIN "predictions" ON "predictions"."userId" = "users"."id"
  INNER JOIN "matches" ON "matchId" = "predictions"."matchId"

await kysely
  .selectFrom('users')
  .innerJoin('predictions', 'predictions.userId', 'users.id')
  .innerJoin('matches', 'matchId', 'predictions.matchId')
  .select('users.id')
  .select((eb) => [
    eb.fn.countAll().filterWhere('predictions.userId', '=', 'users.id').as('apperances')
  ])
  .execute();

await kysely
  .selectFrom('users')
  .innerJoin('predictions', 'predictions.userId', 'users.id')
  .innerJoin('matches', 'matchId', 'predictions.matchId')
  .select('users.id')
  .select((eb) => [
    eb.fn.countAll().filterWhere('predictions.userId', '=', 'users.id').as('apperances')
  ])
  .execute();

WITH
  "ongoing" AS (
    SELECT
      EXISTS (
        SELECT
        FROM
          "matches"
        WHERE
          "kickOff" BETWEEN NOW() - INTERVAL '2 hours' AND NOW()
      ) AS "is_ongoing"
    FROM
      "matches"
    LIMIT
      $1
  )
SELECT
  "matches".*
FROM
  "matches",
  "ongoing"
WHERE
  "kickOff" > NOW()
  AND CASE
    WHEN "ongoing"."is_ongoing" = TRUE THEN FALSE
    ELSE TRUE
  END
ORDER BY
  "kickOff" ASC
LIMIT
  $2

WITH
  "ongoing" AS (
    SELECT
      EXISTS (
        SELECT
        FROM
          "matches"
        WHERE
          "kickOff" BETWEEN NOW() - INTERVAL '2 hours' AND NOW()
      ) AS "is_ongoing"
    FROM
      "matches"
    LIMIT
      $1
  )
SELECT
  "matches".*
FROM
  "matches",
  "ongoing"
WHERE
  "kickOff" > NOW()
  AND CASE
    WHEN "ongoing"."is_ongoing" = TRUE THEN FALSE
    ELSE TRUE
  END
ORDER BY
  "kickOff" ASC
LIMIT
  $2

const countries = [
    { id: 1, name: 'UK', continent: 'Europe' },
    { id: 2, name: 'France', continent: 'Europe' }
];

await db.insertInto('countries')
    .values(countries)
    .onConflict(oc => oc
        .column('id')
        .doUpdateSet(eb => ({
            name: eb.ref('excluded.name'),
            continent: eb.ref('excluded.continent')
        }))
    )
    .execute();

const countries = [
    { id: 1, name: 'UK', continent: 'Europe' },
    { id: 2, name: 'France', continent: 'Europe' }
];

await db.insertInto('countries')
    .values(countries)
    .onConflict(oc => oc
        .column('id')
        .doUpdateSet(eb => ({
            name: eb.ref('excluded.name'),
            continent: eb.ref('excluded.continent')
        }))
    )
    .execute();

import type { ApplicationCommandType, ChatInputApplicationCommandData, CommandInteraction } from 'discord.js';

type ISlashChatCommandNames = 'foo' | 'bar';

export interface ISlashChatCommandData extends ChatInputApplicationCommandData {
    name: ISlashChatCommandNames;
    type: ApplicationCommandType.ChatInput,
}

export interface ISlashChatCommandInteraction extends CommandInteraction {
    commandName: ISlashChatCommandNames;
    commandType: ApplicationCommandType.ChatInput,
}

import type { ApplicationCommandType, ChatInputApplicationCommandData, CommandInteraction } from 'discord.js';

type ISlashChatCommandNames = 'foo' | 'bar';

export interface ISlashChatCommandData extends ChatInputApplicationCommandData {
    name: ISlashChatCommandNames;
    type: ApplicationCommandType.ChatInput,
}

export interface ISlashChatCommandInteraction extends CommandInteraction {
    commandName: ISlashChatCommandNames;
    commandType: ApplicationCommandType.ChatInput,
}