Querying Joins and Nested tables issue

create table profiles {
  "id" uuid primary key,
  -- ...
  "created_by" uuid references profiles, -- profiles_created_by_profiles_id_fk
  "updated_by" uuid references profiles -- profiles_updated_by_profiles_id_fk
};

create view profiles_with_crew_owner_home_places as (
  select p.id as profile_id
  -- ....
);

select p.id, q.profile_id from profiles as p
join profiles_with_crew_owner_home_places as q on p.id = q.profile_id
where p.id = 'abc';

const { data, error } = await supabase.from('profiles')
  .select(`
    id, profiles_with_crew_owner_home_places(profile_id)
  `)
  .eq('id', 'abc');

const { data, error } = await supabase.from('profiles')
  .select(`
    id, profiles_with_crew_owner_home_places!profiles_created_by_profiles_id_fk(profile_id)
  `)
  .eq('id', 'abc');