How to express optional relations?

[Sejmou]

Hi,

I love the relational queries feature, it's a huge time and mental energy saver for me, thanks for that 🙏🏻

However, there's one thing I couldn't figure out: How can I express that a one-to-one relationship is optional?

My use case is the following: in Prisma, I have expressed that a SongFileLink may potentially be associated with a GoogleDriveFile, like this:

model GoogleDriveFile {
  id          String    @id
  downloadUrl String
  songFile    SongFile?
}

model SongFileLink {
  songId               String           @db.Uuid
  description          String
  url                  String
  song                 Song             @relation(fields: [songId], references: [id], onDelete: Cascade, onUpdate: NoAction)
  googleDriveId        String?          @unique
  GoogleDriveFile      GoogleDriveFile? @relation(fields: [googleDriveId], references: [id])

  @@id([songId, name], name: "songFileId")
}

How can I do the equivalent thing in drizzle? The docs just show an example for when there is always an exact-one-to-one mapping (like a foreign key in a DB that is not nullable)

[giopetris]

@Sejmou did you figure it out? Trying to do the same