[FEATURE]: Add documentation in Goodies on how to get materialized view (or view) columns for select

[pencilcheck]

Describe what you want

const columns = getMaterializedViewConfig(materializedView).selectedFields;

We have a section to show how to get the select columns for pg table but not views nor materialized view. If someone can add the example using the code above that would be awesome.

[brncsk]

For anyone looking for a way to infer a matview's select model, this is the way to go:

import type { InferModelFromColumns } from 'drizzle-orm';

export type MatViewSelectModel<M extends PgMaterializedView<string, any, Record<string, PgColumn>>> =
  InferModelFromColumns<M['_']['selectedFields'], 'select'>;

// Usage:
declare const matView: PgMaterializedView<string, any, Record<string, PgColumn>>; // <- this should be your matview object defined using `pgMaterializedView()`
type M = MatViewSelectModel<typeof matView>;

[juliomuhlbauer]

For anyone looking for a way to infer a matview's select model, this is the way to go:

import type { InferModelFromColumns } from 'drizzle-orm';

export type MatViewSelectModel<M extends PgMaterializedView<string, any, Record<string, PgColumn>>> =
  InferModelFromColumns<M['_']['selectedFields'], 'select'>;

// Usage:
declare const matView: PgMaterializedView<string, any, Record<string, PgColumn>>; // <- this should be your matview object defined using `pgMaterializedView()`
type M = MatViewSelectModel<typeof matView>;

This does not work with aliased columns: https://drizzle.run/piy3qe6lr8d7eanurd3q191u

Issue: #3392