[ENHANCEMENT] Support geography type in PG

### What version of `drizzle-orm` are you using?

0.28.6

### What version of `drizzle-kit` are you using?

0.19.13

### Describe the Bug

`drizzle-kit push:pg` does not complete when using a custom type and trying to push the schema to a postgres with postgis installed (using docker); it stops with the following error:

`error: type "geography(Point)" does not exist`

I've created a minimal reproduction:

https://codesandbox.io/p/sandbox/wandering-brook-vwwtj2

### Expected behavior

The push command should complete without error. I can manually alter the table and add a column with the geography(Point) data type, so the database setup seems to be ok.

### Environment & setup

Locally (Fedora) and on codesandbox