feature(core): support for querying based on relationship create time

fixes #2343 

added docs and unit tests

replaces #7514
February ends with a y