There are some queries you want to reuse in different contexts or with different objects quite frequently. You can save it to Queries (previously called Favorites) and assign a keyword for reference and call it quickly using that keyword later.
To add a query to favorite:
- Select the query from the editor (you can also choose from history tab)
- Right-click and choose Add to Queries, then name the query
- Right-click the saved query in the Queries tab, choose Edit/Rename... and add its binding keyword
- Hit Cmd + S to save the changes and then close the window.
Later, when you want to use a favorite query, type the assigned keyword, accept the suggestion and TablePlus will insert that query into the editor.
For example, I have a query that shows all records with stock >= 30 and price >= 90 from the table products.
I save it to Queries and add q30p90 as the binding keyword.
Now I just have to type q30p90 to call that query each time I need to run it.
