🚀 Feature: Self-relations for database

[zerogravity2020]

🔖 Feature description

I see that at this time we can't create a self-relation between one collection

🎤 Pitch

Collection
products: { $id: .... products: [$id] }
Example https://www.prisma.io/docs/orm/prisma-schema/data-model/relations/self-relations

👀 Have you spent some time to check if this issue has been raised before?

• I checked and didn't find similar issue

🏢 Have you read the Code of Conduct?

• I have read the Code of Conduct

[gewenyu99]

The proper way to do this is through a relationship table. The ERD should look like this:

{ user:
  [
    follower:
      [
        user1: {...}
        user2: {...}
        user3: {...}
      ]
   ]
}

user -> related to -> follower -> related to -> user. The followers table would help track user -> user self-relations.

[zerogravity2020]

Hi @gewenyu99 - thanks for the update. Also filters queries doesn't work with related items. It's also huge problem :/