This is what Substrait and Apache Arrow seek to solve; but by serializing query plans that can be produced/consumed by different engines. It’s like an IR for sql.

https://substrait.io/