Upgrade postgrest-js to 1.17

[ex0ns]

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

I have had some typing issues with my queries, most of the errors are now resolved in postgrest-js 1.17 however it seems that the upgrade to 1.17 has been reverted on main, is there a reason for that ?
Is there something we could help with in order to upgrade postgres-js to 1.17 in this repo ?

To Reproduce

Writing a query where the join key is nullable and spreading the join is not making the inner columns nullable:

  let result1: SelectQueryFromTableResult<
    'table1',
    `id, ...table2(table_id:id, table_name)`
  >

If the table2_id in table1 is number | null then both table_id and table_name should be null in the resulting type. This is not the case right now but is fixed in postgrest-1.17

Expected behavior

The generated types should be correct

System information

• OS: osx
• Version of supabase-js: [e.g. 6.0.2]
• Version of Node.js: [e.g. 10.10.0]

Additional context

• 0585c01 revert
• 029465b upgrade to 1.17

[ex0ns]

Done in https://github.com/supabase/supabase-js/releases/tag/v2.47.8, thanks ! (https://github.com/orgs/supabase/discussions/30324)