A developer must perform a complex SOQL query that joins two objects in a Lightning...

Write the query in a custom Lightning web component wrapper and invoke from the Lightning component.

Invoke an Apex class with the method annotated as @AuraEnabled to perform the query.

Use the Salesforce Streaming APL to perform the SOQL query.

Create a flow to execute the query end invoke from the Lightning component.