TypeScript support for undefined values

[sambecker]

In order to accept undefined in queries, I've applied the following configuration:

export const sql = postgres(process.env.POSTGRES_URL, {
  transform: { undefined: null },
});

But then TypeScript says its usage is not valid:

// TS Error: 'ParameterOrFragment<never>'.ts(2769)
sql`UPDATE table SET field=${undefined} WHERE id=${1}`

Is there a recommended approach to loosen the types?

[insidewhy]

In the types/index.d.ts changing the following definition:

type Serializable = never | null | boolean | number | string | Date | Uint8Array

To include undefined fixes this.

[insidewhy]

Wherever you use Sql you can use Sql<Record<string, undefined>> and wherever you use postgres you can use postgres<Record<string, undefined>> and then this seems to be fine.