[FEATURE]: sqlite: deferrable foreign key relations

[ItzDerock]

Describe what you want

Would love to see support for deferrable foreign key constraints, maybe something like:

latestGeneration: text("latestGenerationId")
  .notNull()
  .references(() => generation.id, {
    deferrable: true,
    initially: "immediate",
  }),

Similar to #1429 but for sqlite and instead focuses on fk constraints instead of unique constraints.

afaik there's no workarounds for this rn as I don't think you can add in custom SQL to the end of a column definition, would love to be wrong though.