fix: handle foreign key toward non primary key

[GuillaumeCisco]

Pull Request checklist:

• [x] Write an explicit title for the Pull Request, following Conventional Commits specification
• [x] Create automatic tests
• [x] No automatic tests failures
• [x] Test manually the implemented changes
• [x] Review my own code (indentation, syntax, style, simplicity, readability)
• [x] Wonder if you can improve the existing code

[forest-bot]

Task linked: CU-9uy6b1 Foreign Keys - Support foreignKeys pointing to non primaryKeys

[forest-bot]

Task linked: CU-cayemp Lumber - Operators want to properly read and navigate on relationships with foreign keys that target non-primary keys

[forest-bot]

:tada: This PR is included in version 3.10.8 :tada:

The release is available on:

• npm package (@latest dist-tag)
• GitHub release

Your semantic-release bot :package::rocket:

[forest-bot]

:tada: This PR is included in version 4.0.0-beta.5 :tada:

The release is available on:

• npm package (@beta dist-tag)
• GitHub release

Your semantic-release bot :package::rocket: