Multiple Predicates Within A Single Query

This issue tracks the work for supporting multiple predicates within the same query (especially for FILTER clauses). Phase 1 implements the main functionality. Phase 2 will also support ORDER BY with the same syntax.

Part of #7519

Start by reviewing the related issue #7519 and the existing query syntax and handling for FILTER clauses. Determine the scope and design for Phase 1 multiple predicates, then assess how Phase 2 would extend the same syntax to ORDER BY; completion should include agreed behavior for both phases.

Written by the indexing model from the issue text.