The query on repository is a helper for experienced users to query on the repository based on SQL statements.
In the query textbox you can enter a SQL query. When you push the Load data button the resultset (of a selectstatement will be displayed in the grid at the bottom of the screen.
When you want to do an update on the content you can create a manipulation command in the textbox and press the Execute button.
Eventually you can export the data to an excel file when relevant
When security is enabled you need to have administrator rights to execute these commands