I'm using type orm query builder in my nestjs graphql project, and i need to create a query builder for the below SQL query
SELECT ld.call_sign, rs.tmus_description, te.tmo_entity_name, ld.frn, ld.radio_service_code, ld.license_status, ld. grant_date, ld.expired_date
FROM license_details AS ld
JOIN tmo_entities AS te
ON ld.frn = te.frn
JOIN radio_services as rs
ON ld.radio_service_code = rs.radio_service_code
WHERE ld.license_status = 'A' and ld.entity_type = 'L'Note: I haven't specified any relation between these tables in my database so as in the entity class too. Is it possible to get result from the query builder without specifying the relational fields in entity class.