How to perform joins on non-primary columns and complex select statements in loopback 4?

Describe the bug

Hi i am new to loopback and need to create an API with business logic that contains several complex queries. I cant seem to find a way to join two tables with non-primary columns. For example, select * from e_c left join e on e.ed=e_c.ed Table relations: e_c.ed fk to ed table on id e.ed fk to ed table on id

On the same note writing complex select statements are also needed. For example, select (case when completed_on is null then 1 else 0 end) flag from e or select sum(rating) from f_b

Kindly provide some method by which these can be achieved via loopback 4

Logs

No response

Additional information

No response

Reproduction

No se nombra ningún archivo fuente, prueba ni punto de entrada. Empieza revisando las API de relaciones y consultas de LoopBack 4 comparándolas con los ejemplos de joins sobre columnas que no son primarias y de SELECT complejas; se considera terminado cuando se identifique un enfoque compatible documentado o se documenten claramente la limitación y el alcance necesario.