ParserError: Expected identifier at `)` when using relation with no columns selected

[vladshcherbin]

Bug report

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

Describe the bug

When using anti-join and not selecting any columns, ParserError is shown.

Query:

await supabase
  .from('cars')
  .select('id, car_images()')
  .is('car_images', null)

Error:

The query is working and returns correct results, only typescript is showing this error with no types as a result. After adding any field (for example car_images(id)) the error disappears and typings are correct.

Article with similar example (nominations relation): https://supabase.com/blog/postgrest-11-prerelease#anti-joins

Expected behavior

No typescript typings error, return type should not have this relation.

Screenshots

System information

• OS: macOS
• Browser (if applies) [e.g. chrome, safari]
• Version of supabase-js: 2.26.0
• Version of Node.js: 18.16.0
• Version of Typescript: 5.1.6

[soedirgo]

Thanks @vladshcherbin! This is a new feature from PostgREST v11 (using nested() in v10 would result in an error), so flagging this as a feature request.

[github-actions[bot]]

:tada: This issue has been resolved in version 1.12.0 :tada:

The release is available on:

• GitHub release
• npm package (@latest dist-tag)

Your semantic-release bot :package::rocket: