Epic: #3547

Is your feature request related to a problem?
This issue will do two items:

1. Revert stream pattern method to recover pushdown ability in V2 because previous patterns command in V2 is an expression over new field as part of project, it can be pushed down to OpenSearch. The stream pattern method introduction causes regression. So revert this part of code.
2. Implement SIMPLE_PATTERN patterns method based on parse command in Calcite

What solution would you like?
A clear and concise description of what you want to happen.

What alternatives have you considered?
A clear and concise description of any alternative solutions or features you've considered.

Do you have any additional context?
Add any other context or screenshots about the feature request here.