[Bug]: INSERT ... SELECT * ... does not respect query rewrite hint.

### Is there an existing issue for the same bug?

- [x] I have checked the existing issues.

### Branch Name

main

### Commit ID

HEAD

### Other Environment Information

```Markdown
- Hardware parameters:
- OS type:
- Others:
```

### Actual Behavior

Create database foo;
use foo;

create table t (i int, j int);
create table t2(i int, j int);
insert into t select result, result from generate_series(1, 100) tmp;

set enable_remap_hint = 1;

-- the following works. only 10 rows selected
/*+ { "rewrites": { "foo.t": "select * from foo.t where i < 10" } } */ select * from t;

-- the following will insert 100 rows into t2; this is a bug that will leak data
/*+ { "rewrites": { "foo.t": "select * from foo.t where i < 10" } } */ insert into t2 select * from t;

### Expected Behavior

_No response_

### Steps to Reproduce

```Markdown
See above.
```

### Additional information

_No response_