[Query engine] Find sharding key using SELECT if not in query

[levkk]

Description

Fetch the sharding key for related (foreign key) table when client doesn't provide it in the query.