Release Notes - Version 2.0.1

In version 2.0.1, the application has been completely rebuilt, delivering significant improvements in usability, productivity, and security.

Below are the key highlights of this release:

Search and Filter Functionalities

• Added a filter for selecting eSpaces and Entities.
• Users can now search for both entities and their corresponding physical tables.
• Implemented mandatory use of row limit in queries (configurable via site property).
  
  

New SQL Editor

• Integrated a modern SQL editor powered by the CodeMirror library.
• Result table with horizontal and vertical scrolling and fixed headers.
• Added a splitter to dynamically adjust the size of the editor and results area according to user needs.

Operation Modes

• Read-Only Mode: Allows only read queries and enforces the use of WITH(NOLOCK) to ensure data integrity.
• Write Mode: Grants permission to perform write operations on the database.

User Experience Enhancements

• Display of the number of rows returned and the execution time for queries.
• Export query results to table, Excel, or JSON formats.
• Detailed logging of all executed queries in a log table.
• Reuse of previous logs: users can search and reuse previously executed queries.
• Autocomplete functionality with support for all DDL, DQL, DML, DCL, and TCL commands available in the database.
• Automatic suggestions for OutSystems physical tables based on the selected eSpace, with support for commands like FROM, INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN, CROSS JOIN, and NATURAL JOIN during typing.

There was a failure in version 2.0.0 that did not commented the libraries required for the application to work.

Typo fix