Is your feature request related to a problem? Please describe.
When I want to export a large number of records to a file, the way it works now is by first showing the records in Visual Studio, and then you can export those records to CSV or JSON. When the number of records is high, VS is not able to show those records, and the extension stops working, so I need to use other tools, such as DBeaver, to do so.
Describe the solution you'd like
A new command that exports the query result to a file, without showing the result in VS. It could fetch batches of rows (I think DBeaver's default is 1000), and store them in the result file, so it does not need to store them in memory
Describe alternatives you've considered
Add an option to show just the first records, but being able to export the whole result
Is your feature request related to a problem? Please describe. When I want to export a large number of records to a file, the way it works now is by first showing the records in Visual Studio, and then you can export those records to CSV or JSON. When the number of records is high, VS is not able to show those records, and the extension stops working, so I need to use other tools, such as DBeaver, to do so.
Describe the solution you'd like A new command that exports the query result to a file, without showing the result in VS. It could fetch batches of rows (I think DBeaver's default is 1000), and store them in the result file, so it does not need to store them in memory
Describe alternatives you've considered Add an option to show just the first records, but being able to export the whole result