Open
Description
Bug report
- I confirm this is a bug with Supabase, not with my own application.
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
- Make a table returning rpc: https://github.com/manapoolinc/supabase-playground/blob/gwax/rpc-computed-fields/supabase/migrations/20250127194033_create_country_fns.sql#L1
- 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
- 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
- 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
Activity