Howdy! After reading the source and the fine documentation, I've been searching for ho

<a class="user-mention notranslate" data-hovercard-type="user" data-hovercard-url="/us

Inject type from join via raw sql about kysely HOT 2 CLOSED

jordanh commented on June 4, 2024

Inject type from join via raw sql

from kysely.

Comments (2)

koskimas commented on June 4, 2024

Is this what you're after https://kyse.link/V6moD

from kysely.

jordanh commented on June 4, 2024

@koskimas I'm running into two problems, the first I have a work around for but I wanted to raise it in case I am missing something.

This line:

   .leftJoinLateral(
        sql<{model: string}>`unnest(ARRAY[${sql.join(configuredModels)}]::varchar[])`.as<'v'>(
            'v(model)' as 'v'
        ),
        (join) => join.onTrue()
    )

Will render as:

 LEFT JOIN LATERAL unnest(ARRAY[$1, $2]::VARCHAR[]) AS "v(model)" ON TRUE

In the Postgres dialect, "v(model)" (note double quotes) won't create v.model (accessible with v.*, for example) rather, you'll et a column called v(model). Not the end of the world...one can work around that. Curious if there is a way to drop a literal as?

Second thing I'm running into. I ended up cleaning up my code a bit and using RawBuilder<T> to implement a convenience method:

  function unnestedArray<T>(value: T): RawBuilder<T> {
    if (!Array.isArray(value)) {
      throw new TypeError('Value must be an array')
    }

    return sql`unnest(ARRAY[${sql.join(value)}]::varchar[])`
  }

  const batchToQueue = (await pg
    .selectFrom('EmbeddingsMetadata as em')
    .selectAll('em')
    .leftJoinLateral(unnestedArray(configuredModels).as('model'), (join) => join.onTrue())
    .leftJoin('Team as t', 'em.teamId', 't.id')
    .select('model') // <-- Typescript error

The TypeScript error I get is:

No overload matches this call.
  Overload 1 of 3, '(selections: readonly SelectExpression<DB & { em: EmbeddingsMetadata; } & { model: (string | null)[]; } & { t: Nullable<Team>; }, "em" | "model" | "t">[]): SelectQueryBuilder<...>', gave the following error.
    Argument of type 'string' is not assignable to parameter of type 'readonly SelectExpression<DB & { em: EmbeddingsMetadata; } & { model: (string | null)[]; } & { t: Nullable<Team>; }, "em" | "model" | "t">[]'.
  Overload 2 of 3, '(callback: SelectCallback<DB & { em: EmbeddingsMetadata; } & { model: (string | null)[]; } & { t: Nullable<Team>; }, "em" | "model" | "t">): SelectQueryBuilder<...>', gave the following error.
    Argument of type 'string' is not assignable to parameter of type 'SelectCallback<DB & { em: EmbeddingsMetadata; } & { model: (string | null)[]; } & { t: Nullable<Team>; }, "em" | "model" | "t">'.
  Overload 3 of 3, '(selection: SelectExpression<DB & { em: EmbeddingsMetadata; } & { model: (string | null)[]; } & { t: Nullable<Team>; }, "em" | "model" | "t">): SelectQueryBuilder<...>', gave the following error.
    Argument of type '"model"' is not assignable to parameter of type 'SelectExpression<DB & { em: EmbeddingsMetadata; } & { model: (string | null)[]; } & { t: Nullable<Team>; }, "em" | "model" | "t">'.ts(2769)

This is strange to me as I see "model" in the types right there but I haven't walked the source yet to grok why this TS error is happening.

Anyhow, the first bit is the thing that's more interesting. Definitely a corner case. If you don't care to address it I am fine just working around it for now.

from kysely.

Inject type from join via raw sql about kysely HOT 2 CLOSED

Comments (2)

Related Issues (20)

Recommend Projects

React

Vue.js

Typescript

TensorFlow

Django

Laravel

D3

Recommend Topics

javascript

web

server

Machine learning

Visualization

Game

Recommend Org

Facebook

Microsoft

Google

Alibaba

D3

Tencent