Avoid using wildcard search to find the associated children records

This is follow-up of MR Index extended properties defined in property configurations to replace wildcard search with multi-kind search when searching the associated children records. However, it does not come for free. It needs extra call to get the child kinds in order to replace wildcard. But it may be worth given wildcard search is so expensive and using cache mechanism may help reduce the extra calls.

It also switches back to use query_with_cursor in order to search more 10k records.