[FEATURE]: Allow to specify the mode for certain columns upon introspection

### Describe what you want

Some columns require a `mode` setting to be passed to determine the input and output of Drizzle's queries. All of these have a default (like `bigint` type has `number` mode by default) but there are cases where being able to specify how to introspect these columns may come in handy as changing the mode after every introspection can be very annoying.