Expert Query Support for MongoDB Clusters

[tnaum-ms]

Expert Query Support for MongoDB Clusters

We’re actively considering this feature but haven’t scheduled it for a specific release yet.

This is where you come in! Click here #2508 to dive into the details, share your feedback, and help shape its future.

Your votes and opinions will help us set the right priorities. This extension is here to help you, and your insights are the key to making it as impactful as possible. Let us know what you think—after all, no one knows your needs better than you!

Summary

The current Collection View supports only a simple find filter query. While this provides a basic interface for querying documents, it lacks flexibility and limits the user’s ability to refine or customize queries. This RFC proposes exploring and potentially implementing two scenarios to enhance query capabilities:

1. Enhanced Entry-Level Mode: Extend the existing find filter by adding support for projection and sort fields.
2. Expert Mode: Introduce a free-text query input with intellisense support, providing advanced users with a more powerful querying experience.

Details

Scenario 1: Enhanced Entry-Level Mode

The current query filter would be expanded to include:

• Projection: Specify which fields to include or exclude in the output.
  • Example: { "name": 1, "age": 1 } to include only the name and age fields.
• Sort: Define sorting for query results.
  • Example: { "age": -1 } to sort results by age in descending order.

This mode caters to users seeking simple but slightly more refined queries without overwhelming complexity.

Scenario 2: Expert Mode

Introduce an expert mode allowing free-text input for more advanced query construction. This would include:

• Intellisense Support: Assist users with suggestions, syntax completion, and validation.
• Advanced Query Features: Decide whether to limit inputs to the find syntax or support additional MongoDB query features such as:
  1. Aggregation Pipelines: Enabling transformations and complex queries in the same interface.
     • Example: { $match: { age: { $gt: 30 } } }, { $group: { _id: "$city", avgAge: { $avg: "$age" } } }
  2. Update Queries: Allowing modifications directly from the query view.
     • Example: { $set: { status: "active" } }