Can I use incremental, time travel, and snapshot queries with hudi only using spark-sql?

I'm trying to do incremental, snapshot, and time travel queries using spark-sql with hudi, but the only way that I can find to do this is creating a DataFrame with spark.read and then creating a temp view. Is there any way to accomplish this with only using spark-sql? This is in an EMR cluster, version 6.6.0.