[Feature] Supports read-optimized via hints

[zhuyufeng0809]

Search before asking

• [x] I searched in the issues and found nothing similar.

Motivation

When need to improve query performance, one of the methods is to switch to read the RO table. However, when integrating other systems internally, it is found that the downstream system does not support switching tables, so hope that the query behavior can be changed through hint

Solution

Add table option

Anything else?

None

Are you willing to submit a PR?

• [x] I'm willing to submit a PR!