Test `AS OF` syntax with table redirections

Follow up from the Iceberg time travel PR, ensure that time travel works when using the table redirection feature.

https://github.com/trinodb/trino/pull/10258

cc @findepi @rajarshisarkar 