Creating a custom query is as easy as creating a new query:

• Click the button
• Choose a database, a table, and at least one column
• Simply click on the SQL statement, and you'll see a dialog asking if you want to change the query into a custom query:

• Click "OK" and the query will be changed into a custom query, and you'll be able to edit the query manually.

NOTE: Once you create a custom query, ClickQuery will no longer hilight the columns or tables referenced in the query, and you'll have to create any relationships (joins) yourself. This option was created for "power users".