having the same trouble as this chap in this (stackoverflow issue)[https://stackoverflow.com/questions/71726303/supabase-query-for-one-to-one-foreign-key-return-single-value-not-array]. tldr; how do you flatten the results from a foreign-table query when their is a one-to-one mapping? e.g this.

{
  "id": 1,
  "foreign": [
    {
      "id": 1
    }
  ]
}

to

```
{
    "id": 1,
    "foreign": {
            "id": 1
     }
}

```

Hello @ekko! This thread has been automatically created from your message in #843999948717555735 a few seconds ago. We have already mentioned the @User so that they can see your message and help you as soon as possible! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ``...`` menu) and select "Leave Thread" to unsubscribe from future updates. Want to change the title? Use the ``/title`` command! We have solved your problem? Click the button below to archive it.