[Feature Request]: SNAPSHOT/CLONE usability 1. CREATE SNAPSHOT

### 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 following, aidemo is the database name. It should be
-- optional, if not provided, it should be current database.
-- and, if provided, it should be aidemo.ai_database_clone
-- that is, an object such as table, should always be in the form
-- of a "qualified" name like Account.Db.Table, with current
-- account, current db as default.
-- finally, the error message is not good at all.
--
-- Error 1064 (HY000): SQL parser error: You have an
-- error in your SQL syntax; check the manual that
-- corresponds to your MatrixOne server version for the right
-- syntax to use. syntax error at line 1 column 63 near
-- ".ai_dataset_clone;";

CREATE SNAPSHOT aids_clone_v0 FOR TABLE aidemo ai_dataset_clone;
```

### 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_