Pipeline - use a SQL script as a source

I have a SQL script that queries DataLake storage gen 2 using openrowset.

I'd like to copy the output to a table in Azure SQL.

Is it possible to reference a saved SQL script query for a source dataset in a pipeline?