Seems like the types for many to many relationships are not working in v2

[mzalevski]

Consider following generated types:

export interface Database {
  public: {
    Tables: {
      users_skills: {
        Row: {
          user_id: string;
          skill_id: number;
        };
      };
      users: {
        Row: {
          id: string;
          created_at: string;
          name: string | null;
        };
      };
      skills: {
        Row: {
          id: number;
          created_at: string;
          name: string;
        };
      };
    };
  };
}

when I try to supabase.from("users").select("*,skills(*)") I get

{
    id: string;
    created_at: string;
    name: string | null;
} & {
    skills: unknown;
}

I tried some things from the postgrest docs but nothing is working. Am I doing something wrong or is this inference not ready yet?

[soedirgo]

Hey there, typings for embedded tables is still a WIP, but we have a PR that allows you to override the return type.

[mzalevski]

Thanks @soedirgo. I'll be waiting then :)

[soedirgo]

Closing this as we've since added typings for embedded tables