Multiple Create: Identify and document the limitations and breaking changes.

[severussundar]

Identify and document all the breaking changes introduced by the feature.

Breaking changes refers to any current setup that is working successfully that would stop working when the feature flag for nested create is switched on.

[ayush3797]

When the nested inserts are enabled:

1. Till now, for queries, we were giving preference to the relationships defined by the user in the config over the relationships defined in the database. This behavior will now change via: Removing wrong foreign key definitions #1997:

• If the relationships defined in config and database are identical, we are good.
• If the relationships defined in config and database are not identical, we throw an exception. This is because for nested insertion, we need to obey the relationship defined in the database.

2. Users can no longer define multiple relationships between same pair of (source, target) entities. This behavior will be implemented via: Adding validation to disallow multiple relationships between same source and target entities #1929.
   Side note: Even though defining multiple relationships between same source and target entities is allowed when the nested inserts are disabled, this is still a bug because we don't obey multiple relationships. Related issues: [Bug]: Multiple Foreign Keys on same table causes null response #1859, Multiple relationships between same source and target entities #1930, [Bug]: T-SQL Generated for a Self-Joining Table is Invalid #1940

[seesharprun]

What is the documentation action item for this task?