[BUG]: QuestDB over Postgres API

### Report hasn't been filed before.

- [x] I have verified that the bug I'm about to report hasn't been filed before.

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

0.44.3

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

0.31.4

### Other packages

_No response_

### Describe the Bug

I'm trying to use drizzle for a connection to a QuestDb instance. Their examples are using pg lib for making requests so it should be compatible, but the problem seems to be that drizzle is trying to query non-existent postgres tables since QuestDB is not actually a fully fledged Postgress database.

// drizzle-kit studio
error: table does not exist [table=pg_tablespace]
error: table does not exist [table=pg_am]

// drizzle-kit pull
error: table does not exist [table=pg_catalog.pg_user]

My current set up is questdb image running in docker, and a monorepo with the db package conaining only drizzle config and the schema + connection ts files and a nextjs app that uses this package. Not sure what's the best way to provide a minimal reproduction steps, for getting the drizzle-kit errors, all you need is to spin up that docker instance and try running drizzle-kit commands against it.