Related data when relationships don't exist in database



Is it possible to get related data back where physical relationships don’t exist in the database. We have a data mart, and we have logical relationships not enforced by referential integrity, but need to join tables on an ad-hoc basis.




Currently the relationships are determined solely on the database schema detected, so these logical relationships can’t be returned by DreamFactory. This is not a bad idea for a feature request for v2.0, so I’ve recorded it for our engineers.



That would be great. Often you might want to join a table to a view for example. Being able to define the child table and the join would be very helpful.




This is covered by the v2 feature of virtual relationships. Just commenting for the sake of marking this resolved.