Execute TSQL against a SQL Server from Powershell without SQL Server Management Studio modules installed

TSQL_Query.ps1

$connectionString = "Data Source=cidbsql.cwserverfarm.local;Initial Catalog=workdb;Integrated Security=True;Application Name=PowerSheQL";
$SQL = "SELECT TOP 5 * FROM dbo.RE_Trace;";
$dbc = New-Object System.Data.SqlClient.SqlConnection($connectionString); 
$dbc.Open();

$sqlcmd = $dbc.CreateCommand();
$sqlcmd.CommandTimeout = 1;

$sqlcmd.CommandText = $SQL;
$sqlcmd.Prepare();

$sqlReader = $sqlcmd.ExecuteReader();

$Datatable = New-Object System.Data.DataTable;
$Datatable.Load($SqlReader);
$dbc.Close();
$Datatable;