[Feature Request]: Support Temporary Views

### Is there an existing issue for the same feature request?

- [x] I have checked the existing issues.

### Is your feature request related to a problem?

```Markdown

```

### Describe the feature you'd like

Add support for TEMP VIEW. Reference: [Snowflake Community - How to create a temporary view](https://www.google.com/search?q=https://community.snowflake.com/s/article/How-to-create-a-temporary-view-in-Snowflake)

### Describe implementation you've considered

_No response_

### Documentation, Adoption, Use Case, Migration Strategy

```Markdown

```

### Additional information

_No response_