So… use one of the engines with better support for materialized views?

This sentiment is like saying, "Java doesn't support traits, so I hate all programming languages."

If an engine doesn't support a feature you need, use a different engine. If your workplace does not allow this, that's an issue you have with your workplace, not the tools.