Supabase is an open source Firebase alternative. Start your project with a Postgres database, Authentication, instant APIs, Edge Functions, Realtime subscriptions, and Storage.

Supabase

I have Schemas:
- User {id, name, email, posts: Post[]}
- Post {id, title, content, userId}

When I select user with supabase-js SDK, I want the user data such as it gives:
{id: 1, name: "soham", email:"sohamshah456@gmail.com", posts:[{id:1, userId:"1", title:"Wow", content:"I am content"}, {id:1, title:"Wow", content:"I am content", userId:"1"}]}

Basically, I want the data to be populated. How to do this with our supabase-SDK SQL query?