title: Can we write a Insert query Lookup Activity in ADF
body: <p>At the end of the pipeline I wanted to write the below query
  INSERT INTO [TestTable] (Job_name, status) VALUES (Job_name, current_timestamp()).</p>
  <p>Jobname will be passed as a parameter.</p>
  <p>Can this be written in Lookup, please let me know.</p>