Invalid types for bigint and bigserial

[elahti]

It seems that sqltyper version 0.2.3 (I'm using PostgreSQL version 12 and pg 8.0.3) generates unexpected string types for bigint and bigserial fields.

Using table definition

create table t (
    a integer,
    b bigint,
    c bigserial
)

and query

insert into t (a, b, c) values (${a}, ${b}, ${c})

one gets following .ts code with sqltyper (removed comments from top of the file):

import { ClientBase } from 'pg'

export async function insertToT(
  client: ClientBase,
  params: { a: number | null; b: string | null; c: string },
): Promise<number> {
  const result = await client.query(
    `\
insert into t (a, b, c) values ($1, $2, $3)
`,
    [params.a, params.b, params.c],
  )
  return result.rowCount
}

[akheron]

Bigint and bigserial are returned as strings by node-postgres, because all bigints don't fit in the JavaScript number type (53 bits of precision). See brianc/node-postgres#353. Sqltyper's output has to match the node-postgres runtime semantics.