Topics

Kysely•4mo ago

.filterWhere inference

I have this in a select

  .coalesce(
    fn
      .jsonAgg(
        jsonBuildObject({
          id: ref("i.id"),
          label: ref("i.label")
        })
      )
      .filterWhere("i.id", "is not", null),
    sql`[]`
  )
  .as("interests")

  .coalesce(
    fn
      .jsonAgg(
        jsonBuildObject({
          id: ref("i.id"),
          label: ref("i.label")
        })
      )
      .filterWhere("i.id", "is not", null),
    sql`[]`
  )
  .as("interests")

The result is being inferred as { id: string | null; label: string | null }[] Shouldn't it be { id: string; label: string }[] ?

Solution:

You can use .$narrowType for this.

Jump to solution

6 Replies

Igal (mobile)•4mo ago

Hey 👋 Due to type complexity and performance filtering methods do not affect the output type.

subhxshOP•4mo ago

Ah. I see. But how do I remove the null manually. I've used .$notNull and it results in interests being any

Solution

Igal (mobile)•4mo ago

You can use .$narrowType for this.

subhxshOP•4mo ago

Gotcha. Will check it out

Igal (mobile)•4mo ago

Also, that sql template tag should be given an output type manually.

subhxshOP•4mo ago

Thank you. Typing the sql tag fixed it.

1.7KMembers

View on Discord

Want results from more Discord servers?

Add your server