Swift Supabase table relationship and query

[davidbkemp1]

Body

Working with swift. I have two supabase tables where table A can only have one record of table B related, but a record in Table B can be related to many records in table A. (a family can only have one user as a creator and must have a creator, but a user can be the creator of many families or none) In swift want creator to be loaded as a user object. I have tried all kinds of relationships between tables and queries to select families and get various errors.

Table A: family
id: UUID
name: text
description: text
creator: UUID

Table B: user
id: UUID
first_name: text
last_name: text
email: text

Guidelines

• I have read and understood this category's guidelines before making this post.