Data Export Limitations

We had built a query compiling over 6 months worth of data that we needed to export to a csv. When attempting to export the report, which had fully generated, we were met with a download failed message. We have learned that the export feature has a data limitation which is smaller than what the query builder can generate. This is not user friendly at all, as we now need to either have multiple versions of the query to get the data needed or adjust the date range then export, then adjust the date range again and export. Please expand the export limitation to match what the query builder can do or give some sort of option to approve the export even if it will take longer to do.