[FEATURE]: Optional One-to-One Relation

[413n]

Describe what you want

Currently it's possible to define only a One-to-One relation (https://orm.drizzle.team/docs/rqb#one-to-one) but in the types, the value returned will never be undefined or null.
In my use case I would like to define a One-to-One relation that could be optional.
Is there a solution? Is this even possible?

[tarekwiz]

+1. I think the types should at least be T | undefined instead of T

[foodornt]

Any idea why it's not already nullable?

[jadamduff]

+1

[agulencina96]

Any update on this?

[amirfakhrullah]

Hey, do we have an update for this?

[j-fdion]

Yes, this one is a must have!

[ghardin1314]

I think you can accomplish with this comment

https://www.answeroverflow.com/m/1126473676804599881

i.e. only put the fields and references on the one who knows about the other. My example oprganization.shopIfyIntegration is nullable

export const shopifyIntegrationRelations = relations(
  shopifyIntegrations,
  ({ one }) => ({
    organization: one(organizations, {
      fields: [shopifyIntegrations.organizationId],
      references: [organizations.id],
    }),
  }),
);


export const organizationRelations = relations(
  organizations,
  ({ one, many }) => ({
    shopifyIntegration: one(shopifyIntegrations),
  }),
);