[Feature Request]: SNAPSHOT/CLONE usability 3: RESTORE

### 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
--
-- the correct syntax should be
-- RESTORE TABLE account.db.tablename FROM SNAPSHOT ...;
-- use qualified name, and supply current account, current db if not
-- specified.
--
-- And the error message is really bad.
--
RESTORE ACCOUNT a
DATABASE aidemo TABLE ai_dataset_clone FROM SNAPSHOT aids_clone_v0;
```

### Describe the feature you'd like

see above

### Describe implementation you've considered

_No response_

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

```Markdown

```

### Additional information

_No response_