Is there a way of formatting data at the collection level on certain queries?
I have a use-case where I have a metadata field that is json, it contains a structure that holds foreign key references to other tables/collections. This can be things like people/location/attachment references.
In postgres I've created a view which enriches this data so when you load the row's metadata it would have the fresh data. Eg if a person changes their name, it would be updated automatically.
Is there anything in tanstack/db & tanstack/react-db that can do something like this? I was hoping there'd be some type of onSelect?
The only approach I've found so far is running the first live query, extracting the metadata from all objects returned then batching those to fetch the additional items to then rebuild it.
Since this would be somewhat heavy compared to other queries where this wouldn't be needed it would be good to only trigger this if that field is requested.
In postgres I've created a view which enriches this data so when you load the row's metadata it would have the fresh data. Eg if a person changes their name, it would be updated automatically.
Is there anything in tanstack/db & tanstack/react-db that can do something like this? I was hoping there'd be some type of onSelect?
The only approach I've found so far is running the first live query, extracting the metadata from all objects returned then batching those to fetch the additional items to then rebuild it.
Since this would be somewhat heavy compared to other queries where this wouldn't be needed it would be good to only trigger this if that field is requested.
