gentype producing wrong type for inner join

[louisgv]

Bug report

• I confirm this is a bug with Supabase, not with my own application.
• I confirm I have searched the Docs, GitHub Discussions, and Discord.

Describe the bug

When creating an inner join via a !inner(*) query, the inferred type returns an array, but the actual data is a single object.

To Reproduce

await supabase
      .from('deadwood')
      .select('*, cs!inner(*)')

Expected behavior

deadwood.cs should be typed correctly

System information

• OS: macOS
• Browser (if applies) [e.g. chrome, safari]
• Version of supabase-js: 1.77.9
• Version of Node.js: 18.x

Additional context

[sweatybridge]

The underlying cause seems to be non-handling of unique constraint. Closing as a duplicate of #612