© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•4y ago•
3 replies
YANN

Is it possible to set the desired return type for a select ?

Hello, let's say I want to query 2 fields like

supabase.from("table").select("id, color");
supabase.from("table").select("id, color");


Ideally I would like to receive the color field in a nested record, as such:

{
    id: 0,
    appearance: {
        color: 5
    }
}
{
    id: 0,
    appearance: {
        color: 5
    }
}


I know this is possible via graphql, but I would like to avoid using it, thanks in advance!
Supabase banner
SupabaseJoin
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.
45,816Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

Is it possible to set a limit on spend cap?
SupabaseSSupabase / help-and-questions
2mo ago
Is it possible to mention type of jsonb
SupabaseSSupabase / help-and-questions
4y ago
Set complex return type = SQL function
SupabaseSSupabase / help-and-questions
4y ago
Is it possible to set the upload owner when uploading to Supabase storage?
SupabaseSSupabase / help-and-questions
3y ago