[engine] Create a group chat - #2725 #2726

Ticket(s) / Related Merge Requests

• Issue card: #2725 (closed)
• Front MR: front!2622 (merged)

Summary of Changes

Refactors the chat queries to do an inner join from a subquery of a UNION between the memberships and group memberships table

Testing Considerations

  mutation {
        createChatRoom(groupGuid: "1559184041146585108", roomType: GROUP_OWNED) {
        id
      }
  }

Deployment Considerations

Regression Scope

Only related to chats

Platform Affected (web, mobile, etc)

Developer Testing Completed

Screenshots / Screen Recording

Does this impact

• Localization
• Dark/light mode
• Guest mode

Definition of Done Checklist

• The Acceptance Criteria has been met
• Code is tested: Testing includes unit/spec, E2E/automated and manual testing
• Merge requests description has been filled out