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.

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.