You can test SQL statements for queries as well as for commands by using the <Test statement> button.

Technically, the statement is executed during the test in a transaction, which is then undone subsequently (rollback). In a normal case, this avoids the tested execution of an SQL statement leading to changes in the database. This is especially important for writing SQL commands.

Depending on the complexity of the SQL statement and the structure of the database, however, it cannot be completely ruled out that changes remain in the database after the rollback.

Unlike SQL command modules (outputs), there is an area with SQL query modules at the bottom in the SQL query tab where the test results are displayed.

At this point, a maximum of the first 100 rows of the query result is displayed.

You can also test the statement for SQL commands. However, you only receive feedback as to whether the execution of the statement was successful or not.