feat: Get references from manager about drift HOT 4 OPEN

1. I haven't experimented with how nesting would be done. It's isn't supported in my current implementation. Even so there wouldn't be any circular recursion issues.
2. Once withReferences is called, it uses whatever filters and ordering were applied to the manager and wraps it in a new class. It will then run queries to get the referenced objects and attach them to a record. So filters and ordering can't be applied to what references get returned. Serverpod allows filtering what references are returned, but it's not type safe. I think it's worth it to have all-or-nothing and be type-safe

from drift.

@simolus3 Check this out #2984

from drift.

The API looks convincing, but I think I need some more details that aren't clear to me (but probably important to get right/clarified first):

1. How (if at all) does this chain multiple reference links (e.g. if categories had outgoing references as well)? How do we deal with circular references (or self-references in a table)
2. How does this play along with the rest of the manager API, in particular the methods to write filters? Will they still only use the primary table or is there a different state for joins as well?

from drift.

I'll have a PR in a couple of minutes which will allow you to experiment with it.
Although modular will prob not work (temporarily)

from drift.