[BUG]: insertions on columns with the smallserial datatype are not optional

[t3ned]

What version of drizzle-orm are you using?

0.29.3

What version of drizzle-kit are you using?

0.20.12

Describe the Bug

The smallserial, serial and bigserial datatypes with the postgres.js driver are configured with hasDefault=true and notNull=true.

However, smallserial is missing the NotNull and HasDefault type helpers wrapped around the builder.

Therefore, when you try to insert a row into a table with a smallserial column, you are required to provide an input.

Example table

export const examples = pgTable("examples", {
    id: smallserial("id").notNull().primaryKey(),
});

Example insert query

await this.drizzle
  .insert(examples)
  .values({}); // Property 'id' is missing in type '{}' but required in type '{ id: number; }'

Workaround

Ignoring the type error successfully inserts a row

await this.drizzle
  .insert(examples)
  .values({} as unknown as typeof examples.$inferInsert);

Expected behavior

smallint columns should be optional when inserting to match the behaviour of serial and bigserial

Environment & setup

Node v20.11.0