CasingCopy page

casing is the SQL spelling of a name you did not set. Insert, update, and where still use the field name. The client name stays the name you passed to table().

omitted

Leave casing out and Postgres stores the name you wrote.

import { schema, table, t } from "okmodel/pg";

const notes = table("notes", {
  id: t.identity(),
  publishedAt: t.timestamptz().nullable(), 
});

export default schema({ tables: [notes] });

snake

"snake" rewrites a camelCase table name and a camelCase field. The first character never gains a leading _. publishedAt is published_at. userID is user_i_d. PublishedAt is published_at. A digit does not insert _, so iso8601Date is iso8601_date. An uppercase letter that already follows _ does not add a second one: user_ID is user_i_d.

sqlName and renamedFrom are stored as you wrote them. Indexes, checks, and foreign keys then use that SQL name.

import { schema, table, t } from "okmodel/pg";

const notes = table("publishedNotes", {
  id: t.identity(),
  publishedAt: t.timestamptz().nullable(), 
  headline: t.text().sqlName("title"), 
});

export default schema({
  tables: [notes],
  casing: "snake", 
});