Comment by joevandyk

Yes, all that’s possible. But it’s not straightforward in the majority of ORMs.