So, for defining a study pipeline, i guess its best just to export the finished study to see how it all ties together and create a script to export data based on that. And referring to the xml reference https://www.labkey.org/download/schema-docs/xml-schemas/index.html?schemas/study_xsd/schema-frame.html ....

Oh, the query snapshot looks like a nice feature. Though, may still have to use the pipeline feature due to one of the external schemas being an Oracle db.