I suspect people are just expecting too much of Substrait, hoping it will magically give you interop. But you need something higher level to bridge semantic differences between systems.

Calcite works well for that if you’re in the JVM. But tooling for native isn’t great.