title: How to do row transformations in Azure ADF?
body: <p>I've a On premise SQL server for which I've configured IR. I want to execute query and transform the output of the query into JSON object. My JSON transformation is complex so can't be done in SQL Server itself. After transformation I need to store the output into ADLSv2. How this can be done in ADF? Ideally I want to write a Python code for doing the row transformations. Can someone suggest me some solution?</p>