title: ADF Mapping Data Flows, is it possible to execute SQL on a source?
body: <p>So I continue to rewrite my lovely SSIS packages to ADF Data Flows. However, there is a lot of cases where I have some OLE DB Source with quite complicated SQL statement followed by other transformations. </p>
  
  <p>Let's say there is a SQL statement which joins 10 different tables. As far as I know I can execute SQL statement <strong>only</strong> on my sink. So to get the very same dataset that is being used later, I have to create 10 different sources and 10 join operations. Is that correct?</p>
  
  <p>It is possible but it doesn't seem to be very efficient. The only other thing that comes to my mind is to re-think our whole DWH logic but it would be a lot of added work, so I would rather avoid that.</p>
  
  <p>Thank you in advance!</p>