joins across schemas with client
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
say
project.videos(id, user_id) and public.users(id, email) - i would want to get the email of a user associated with a video, which normally would be very easy -
id, users(email)