[FEATURE] Core Syntax: Implement ppl `InSubquery` command with Calcite

**Is your feature request related to a problem?**
Implement ppl `InSubquery` command in Calcite


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