Support UNDROP TABLE in Spark SQL

[https://github.com/apache/hudi/issues/6658]

Specifies the identifier for the table to restore. If the identifier contains spaces or special characters, the entire string must be enclosed in double quotes. Identifiers enclosed in double quotes are also case-sensitive.
# Restoring tables is only supported in the current schema or current database, even if the table name is fully-qualified.
# If a table with the same name already exists, an error is returned.
# UNDROP relies on the Snowflake Time Travel feature. An object can be restored only if the object was deleted within the. The default value is 24 hours.

[https://docs.snowflake.com/en/sql-reference/sql/undrop-table.html]

## JIRA info

- Link: https://issues.apache.org/jira/browse/HUDI-4891
- Type: Improvement
- Fix version(s):
- 1.1.0