[Feature Request]: Support creating `trigger`

### 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
Want to support `Trigger` that is supported by MwSQL
```

### Describe the feature you'd like

The following SQL fails:
```
CREATE TRIGGER instance_operation_prevent_delete_before_delete
BEFORE DELETE ON meta.instance_operation
FOR EACH ROW
BEGIN
SIGNAL SQLSTATE '45000'
SET MESSAGE_TEXT = 'DELETE xxx is not allowed on this table';
END;
```

### Describe implementation you've considered

_No response_

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

_No response_

### Additional information

_No response_