Why is a remote INSERT with VALUES clause statement not completely evaluated remotely?

You can check the VALUES clause and the expression to determine why a remote INSERT with a VALUES clause statement is not completely evaluated remotely.

Considerations:
  • Can the VALUES clause be completely evaluated at the remote data source? In other words, does an expression contain a function not supported by the remote data source?
  • Does the expression involve a scalar subquery? Is that syntax supported?
  • Does the expression reference the target table? Is that syntax supported?