Supabase is an open source Firebase alternative. Start your project with a Postgres database, Authentication, instant APIs, Edge Functions, Realtime subscriptions, and Storage.

Supabase

Hello ! I'm trying to query foreign keys from a different table using the following example :

const { data, error } = await supabase
  .from('countries')
  .select(`
    name,
    cities (
      name
    )
  `)

(this is from the documentation), but I had an issue that there were multiple keys and modified by adding the "!" such as entity:attribute! ( other  keys here )

.select(`id,
            name,
            profiles:createdby! (
                id,
                username
            )
        `);

but I'm not receiving the username, I'm only receiving the "id"