Left join for conditional lookups

I found that I can’t choose to do a LEFT JOIN instead of INNER JOIN when I create a conditional lookup field. I understand that it can be dangerous to explode a table but there should be an option to do it. The current solution of creating a custom view to do this is cumbersome in my opinion