Left Join ON parameter value

I’m requesting that left Joining from a parameter be supported - right now it only supports field values:

1 Like

Bumping this one as it is what I am looking for: Query Builder join on parameter value not column

Can someone explain a scenario where you would need this and where a bog standard left join would not fit the bill?

See Query Builder join on parameter value not column. This needs a join on parameter value, or a subquery