jsonArrayFrom integer foreign keys are not converted to strings but the type says string

[Andrew-Chen-Wang]

I have two Postgres tables like this:

Table A: id (auto increment)

Table B: id (auto increment), tableAFK (references Table A)

Then, I perform a select from with jsonArrayFrom:

jsonArrayFrom(
            eb.selectFrom("Table B")
              .select(["Table B.tableAFK"])
          ).as("blah")

The actual returned type is {tableAFK: number} like {tableAFK: 1} instead of {tableAFK: string} like {tableAFK: "1"}. But the typescript inferred type is correct: {tableAFK: string}, the return value is a number though.

[igalklebanov]

Hey 👋

Can you provide a kyse.link that reproduces your issue?

[Andrew-Chen-Wang]

Hey @igalklebanov I tried recreating something minimal: https://kyse.link/HiM0D

To explain, the select from table a is returning an id of type string. The select also returns a JSON array of what I expect to also be of type string[] since the column I am selecting from is type id, and generated columns return string. Instead it actually returns number[]