Row, Insert, and Update models

generateModels(metadata, options) is pure and offline. It returns standalone TypeScript source, model names, diagnostics, metadata/policy provenance, and an options hash.

For a table with a numeric identity id, required email, and no generated/non-writable evidence, codegen emits:

export interface UsersRow {
  id: string;
  email: string;
}

export interface UsersInsert {
  id?: string;
  email: string;
}

export interface UsersUpdate {
  id?: string;
  email?: string;
}

• Row uses the TypePolicy outputType; database nullability adds | null.
• Insert uses inputType; nullable/default/identity columns are optional, while proven non-insertable/generated columns are omitted.
• Update uses inputType; included properties are optional, and proven non-updatable/generated columns are omitted. Identity alone is not a ban.

Exact integer and decimal output types are canonical string; approximate binary types are number. Generated models do not silently decode exact strings to bigint or a decimal object.

Views, materialized views, foreign, and virtual relations receive Row models only. Unknown relation kinds with columns receive a Row model plus a warning. Unsupported or unproven types remain unknown, never any; inspect diagnostics before consuming generated source.

Native parsed JSON roots use unknown unless the selected profile proves a narrower root shape. Scalar mappings also do not recursively certify arrays, ranges, composites, objects, sql_variant, vectors, or other containers. Container-specific evidence is required before generating a nested application type.

Column names remain exact database keys as quoted TypeScript properties when needed. Namespace evidence and stable identity suffixes prevent collisions. Deterministic output does not depend on metadata capture timestamps or object insertion order.