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

Aucun fichier source, test ou point d’entrée n’est indiqué. Commencez par examiner les API de relations et de requêtes de LoopBack 4 en vous appuyant sur les exemples de jointures sur une colonne qui n’est pas la colonne primaire et de SELECT complexes ; le travail est terminé lorsqu’une approche prise en charge et documentée est identifiée, ou que la limitation et la portée requise sont clairement documentées.