Microsoft has released the September update for Azure Data Studio, bringing SQL Server command line mode in the Query Editor, Notebook improvements, the Query Editor Boost extension, and more.

sqlcmd -E -S localhost -i RunBackup.sql -o Backup.log I have simplified this example for brevity, but it's a straightforward example of how sqlcmd could be used to automate simple code.