BUG: introspect generates broken schema when custom types are used

I'm using supabase for auth and db and I would like to use drizzle as the ORM.

To reference the user id I need to introspect the db against the `auth` schema. This runs successfully but the `schema.ts` is broken.

I'm going to post few of the broken parts (with custom types)
```
// TODO: failed to parse database type 'auth.factor_type'
factorType: unknown("factor_type").notNull(),
// TODO: failed to parse database type 'auth.factor_status'
status: unknown("status").notNull(),
```

Also, nullable text fields seem to have a problem:
```
phone: text("phone").default(NULL::character varying),
```
The part with `::character varying` is what makes it broken.

According to drizzle-team/drizzle-orm#3490, also custom functions generate broken schemas.