Question on nested queries.

[nicoabie]

The example shows a one to many relationship between users and posts.

What happens if the relationship is one to one like user and work_address? where the latest instead of being an array should be a single object?

[wsporto]

The documentation shows an example of a one-to-one relationship between customers and addresses in the section "One To One". https://typesql.pages.dev/guides/nested-query-result/

In that case each user will have a single address object as shown below:

/* result type
{
  id: number,
  full_name: string,
  address_id: number,
  address: {
    id: number,
    address: string,
    zip_code: string,
    city: string,
    state: string
  }
}