Query SQL Server from PowerShell
Install the sqlserver module
Install-Module sqlserver -Force
If a minimum NuGet version is required, the command output will tell you how to install it.
Run a query
Invoke-Sqlcmd -Query "SELECT GETDATE() AS TimeOfQuery" -ServerInstance "localhost"
Run a script file
Invoke-Sqlcmd -InputFile "C:\setupscripts\createUser.sql" | Out-File -FilePath "C:\setupscripts\createUser.log"