Using SQL Statements
You can use custom SQL statements get information about your existing tables and to manipulate your data.
The query builder is in Beta Mode. You can use it to generate your own custom queries for your database to return very specific resultsets or even execute UPDATE, INSERT, or DELETE statements, but of course be careful with these.
If you select a table from the query list and click "show sql," a select statement will appear. Click Run Query to return results.
You can save your queries also. If you have selected a table, then save a query, a link will appear to the right of the query list that you can click on to view the results in your browser and save a menu that will display these results for you. You can also use these results in Portals.