[FEATURE] Support for position in the v2 engine

[acarbonetto]

Is your feature request related to a problem?
The POSITION function is available in the legacy engine, but fails for queries that require the V2 SQL parser or PPL parser. LOCATE is already available.

Example:

SELECT POSITION("SS" IN "ISSUE");

What solution would you like?
POSITION is already supported in the legacy engine, and so is LOCATE. Both have similar functionality, and should be both available in the V2 engine.

What alternatives have you considered?
See above

Do you have any additional context?
N/A

[margarit-h]

Internal WIP PR: Bit-Quill#177

[margarit-h]

PR for SQL support: #1121

[margarit-h]

Internal PR for PPL: Bit-Quill#184

[margarit-h]

PR for PPL support: #1147