Implement consistent input validation across all query implementations

[coderabbitai]

Add input validation consistently across all query implementations to ensure data integrity and prevent potential issues.

Validation requirements:

• Check for empty collections
• Check for duplicate entries
• Enforce reasonable size limits

This came up during review of query implementations in PR #2449 (#2449 (comment)).

The validation should be implemented in a consistent way across all query types rather than adding it individually to maintain code consistency and ensure all queries have the same level of input validation.