The Sub-Query data adapter is used to perform queries and transformation against other data source entities. This does not appear in the adapter type chooser when adding a data source, instead select an existing data source and click the Create Sub-Query button.
Sub-Query example configuration.