How are cross-shard queries, joins and unique constraints handled?

Write or say your answer first, then compare it with the model answer.