To read Salesforce data, Lightning web components use a reactive wire service. When the wire service provisions data, the component rerenders. Components use @wire in their JavaScript class to specify a wire adaptor or an Apex method.

Wire Service is reactive. So, it works asynchronously. But the page renders based on the values retrieved.

You cannot chain Wire Service methods. Use dynamic binding instead.

Example – https://www.infallibletechie.com/2019/03/related-list-card-with-filter-and.html