[FEATURE] Support `Patterns` command with Calcite

**Is your feature request related to a problem?**
Patterns command was improved with new algorithm. Need to migrate it to new engine Calcite

**What solution would you like?**
N/A

**What alternatives have you considered?**
N/A

**Do you have any additional context?**
N/A