SQL-script deployment

I would like option to run SQL update or create scripts in the deploy task.

Here’s how I would suggest approaching it: Deploy a SQL Database

A simpler (but far less robust) way would be to just call SqlCMD.exe from a Deploy.ps1 file.