The SQL results pane allows your users to see the results of an SQL query.
The SQL Results Viewer has numerous features:
View query results in a table
View history of previously run queries
Rerun previous queries with a single click
Edit a previously run query
Select a database
The only way to interact with the SQL Results Viewer tab is by using the Code Editor to write queries. Since this is the case it will be best to select a Two Pane (Horizontal) in the Interface Layout section in the Interface tab.
To configure the SQL results viewer, click on the Interface button in the left sidebar, then scroll down the the "SQL Results Display Settings" section. The settings are explained below.
The database to run queries against. Used by the
The type of database that should be used. This can be toggled between MySQL, PostgreSQL, and SQLite.
Whether or not the user is allowed to change the database that the SQL Results Viewer runs queries against. If enabled, the database dropdown (see below) is enabled.
The database dropdown is in the bottom left corner of the SQL Results Viewer. When pressed, a list of all the databases in the project is shown and the user can select a database to run queries against.
Finally, make sure to use the Save button in the top left corner of your screen.