Unable to update items with joins query

[shahzaib78631]

I am unable to update the item when using the joins.

select: (from) => from.select(`*, inventory(whole_count, unit_count)`),

when updating any field in the item i.e items$[item.id].barcode.set(item.barcode); i get following error.

{
  "code": "PGRST204",
  "details": null,
  "hint": null,
  "message": "Could not find the 'inventory' column of 'items' in the schema cache"
}

I am also unable to create new items in supabase. Item is added in local storage but is not created on supabase.

const createItem = (item: Item) => {
    const id = generateId()
    if (itemsTable$) {
      itemsTable$[id].assign({...item, id});
    }
  }

[Crsk]

According to the docs .set triggers an insert in Supabase and you're using .assign, maybe that's why

From the docs

const id = generateId()
// Add keyed by id to the messages$ observable to trigger a create in Supabase
messages$[id].set({
    id,
    text,
    created_at: null,
    updated_at: null
})