supabase-js icon indicating copy to clipboard operation
supabase-js copied to clipboard

Supabase type error when querying computed field of rpc result

Open gwax opened this issue 10 months ago • 0 comments

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

Supabase supports selecting computed fields from RPC results via postgrest but the type system shows an error when attempting to do so.

Errors show up as SelectQueryError<"column ... does not exist on ..."> but the query still works as expected.

To Reproduce

Minimal reproduction is available in the gwax/rpc-compted-fields branch here: https://github.com/manapoolinc/supabase-playground/tree/gwax/rpc-computed-fields

  1. Make a table returning rpc: https://github.com/manapoolinc/supabase-playground/blob/gwax/rpc-computed-fields/supabase/migrations/20250127194033_create_country_fns.sql#L1
  2. Make a computed field on the returned table type: https://github.com/manapoolinc/supabase-playground/blob/gwax/rpc-computed-fields/supabase/migrations/20250127194033_create_country_fns.sql#L11
  3. Query the rpc with a select containing the computed field: https://github.com/manapoolinc/supabase-playground/blob/gwax/rpc-computed-fields/src/lib/db/countries.ts#L37
  4. See type error in IDE and typescript compiler: https://github.com/manapoolinc/supabase-playground/blob/gwax/rpc-computed-fields/src/lib/db/countries.ts#L61

Expected behavior

No Type Errors in reproduction code

System information

  • Version of supabase: 2.6.8
  • Version of supabase-js: 2.48.1

gwax avatar Jan 28 '25 00:01 gwax