Studio 3T 2023.9.0

What's new in this version:

New:
- New: Query Profiler - Find slow running queries, investigate, and fix Mongo DB queries to speed up performance

Improved:
- Include "loadBalanced" option in non-SRV connections for compatibility with Oracle Autonomous Database
- IntelliShell is now able to handle large and complex scripts with better performance
- Added support for custom stage names in aggregation editor
- Detect when an email address is listed in both the "allow" and "block" lists in Team Sharing preferences
- More consistent icons for locked connections
- Support for aggregation stages $listSampledQueries and $listSearchIndexes, and operators $median and $percentile
- For compatibility with Amazon DocumentDB, Studio 3T now doesn't attempt to use "allowDiskUse" and "collation" options unless they differ from the defaults
- IntelliShell's autocomplete suggestions are now case-insensitive
- "Copy selection" contextual option now also available in raw shell output
- In the Query History and Query Browser windows, "Clear History" is now accessible without having to select an item first
- The "Insert JSON Document" feature now accepts an array of documents as well as a single document
- "Refresh" button now available also in IntelliShell results tab and SQL Query results tab
- In IntelliShell results, treat "findOne" results in a manner consistent with "find"
- "Follow Reference" can now remember different target databases and/or collections for different source fields. Also, the choices are remembered even if the tab is closed

Fixed:
- Studio 3T could crash when disabling the trial while having a collection tab open against a shared connection
- Empty folder in connection manager would remain collapsed even after adding a connection to it
- Compatibility problems from 2023.7 on with CSV export tasks created in previous versions
- In the import connections dialog, all the folder options in the dropdown would duplicate each time a file is selected
- Hitting "Ctrl/Cmd + Enter" in IntelliShell would insert a new line in certain cursor positions
- Crash when rapidly removing and re-setting the read-only lock on a shared query
- Input for OpenAI API Key accepted trailing newlines, resulting in an error when trying to use the key
- UUIDs not properly displayed in Visual Query Builder
- Field name proposals in SQL Query Tab could be sourced from the wrong collection if the SQL script had multiple SELECT statements
- Existing indexes sometimes not available for selection for hints in aggregation options
- Editing the index specification for the index hint in aggregation options would cause an error message to appear
- Index hints were not applied to "Explain Query" within IntelliShell
- IntelliShell result tabs would be persisted when restarting the shell, even if not pinned
- Pressing enter when entering an email address in the block or allow list for team sharing would close the preferences