Less than 40 lines and 6 hours

try {
    $cn = New-Object 'System.Data.SqlClient.SqlConnection' 'Server=.;Database=master;Trusted_Connection=True;'
    $cn.Open();
    $cmd = $cn.CreateCommand();
    $cmd.CommandText = 'SELECT name FROM sys.tables'
    $rdr = $cmd.ExecuteReader()
    while ($rdr.Read()) {
        New-Object PSCustomObject -Property @{ Name = $rdr['name']; }
    }
}
catch {
    Write-Error 'Something broke';
    throw
}