How To Export large result set without loading into display

[rwhirn]

1. Which driver are you using and version of it (Ex: PostgreSQL 10.0):
   any

2. Which TablePlus build number are you using (the number on the welcome screen, Ex: build 81):
   130

3. The steps to reproduce this issue:
   If you do either a filter of a table or a custom SQL command that returns many thousands of rows. A filter produces a display of 1-XXX of YYY,YYY rows, where XXX is however many you set as default and YYY,YYY is rows in result. At this point you can right-click on the display and say "Export Current Page", which is a nice feature, but what about "Export ALL Pages" so I can get all the results of this filter? If you then copy this SQL query into a SQL Command editor, you would have to wait for all YYY,YYY results to load into the display, which could take quite a long while and would most likely blow up the program by running out of memory. So is there some other way to export a large result set?

BTW, I tried KILLing the SQL command query after 10+ seconds and then running the "EXPORT" but the program just hangs after exporting "3 records".