Query snippets are parts of a query that often repeat themselves, and hence can be reused.
For example, a join between tables, a large where [not] in, or simply a frequently used constraint.
Use of the query snippets is time-saving, since now you can autocomplete large pieces of SQL code in seconds, and it can be shared between colleagues.
To create query snippets, go to Settings | Query snippets:
On the query snippets screen, you will see all the previously created snippets.
Click on the +New Snippet button to start creating a new snippet.
The new query snippet page is displayed and the following fields need to be filled in:
Trigger: This is the word that will be used to invoke the query snippet. The query editor will suggest auto-completion for this word when the user starts to type in the first few letters.
Description: This includes several words to describe...