hi. i'm thinking of organizing my tables into schemas, so that it's easier to think about, as i group the tables together by purpose. the only question i have is whether the supabase client is capable of fetching data across multiple schemas. say
project.videos(id, user_id)
project.videos(id, user_id)
and
public.users(id, email)
public.users(id, email)
- i would want to get the email of a user associated with a video, which normally would be very easy -
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.