command query for table data in variable

use case is customer need to export data from multiple data source ex text file , csv, the data export like table structure, if they would like to joining data from multiple tables across different sources—our command-based approach may be more challenging. if we have command query in variable, it should be easy that do loop table command