[FEATURE]: sqlite: deferrable foreign key relations

### Describe what you want

Would love to see support for [deferrable foreign key constraints](), maybe something like:

```js
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.