Bugfixes for deterministic encrypted queries

We discovered a couple of bugs with queries on deterministically encrypted columns and I’ve created PRs for them:

  1. Expand Set values
  2. Support hash join syntax (fixes #46809)

These both caused some errors while migrating some existing data and I’d love to prevent others having the same issues.