Is game_id set to be the primary key of 'results' table? If not then there is no way for supabase to know that there's only going to be one match in 'results' as there is nothing to stop you from having two rows with the same game_id. If 'game_id' is set to primary key then supabase's generated types should have this foreign key given the property 'isOneToOne: true', and then a query like this (possibly needing the addition of an '!inner' on results) will expect an object for 'results' instead of an array.