join on multiple fields

I would like support for joining tables on multiple fields i.e. as a composite primary key. Something similar would be useful for table relationships too. Currently I have to create a custom column that concatenates 2+ fields and match on that