whats the best approach for updating relationships data in the sheet?

[khrnchn]

for example, i have an items datatable with m2m relationship with branch (the pivot table is itemSafetyLevels, where columns = itemId, branchId, and safetyLevel).

i want to be able to update the safety level of an item for all branches in the row's sheet.

my current approach: for table query, include the safety level right away but this requires a lot of hacking around the type (im using drizzle, i just update those Item to ItemWithSafetyLevels but am still stuck with it especially with the useDataTable hook.

i also think of fetching relationships data when opening the sheet.