POWERSHELL: Generate markdown from query

GenerateMarkdown.ps1

Clear-Host

# UPDATE QUERY / SERVER / DB
$serverInstance = "..."
$database = "..."
$query = "
  SELECT * FROM sys.tables 
"
# UPDATE QUERY / SERVER / DB

$lineEnd = [Environment]::NewLine
$skipHeaders = "RowError", "Table", "ItemArray", "HasErrors", "RowState"
$results = Invoke-Sqlcmd -Query $query -ServerInstance $serverInstance -Database $database -Encrypt Optional 


$markdown = ""
if ($results.Count -gt 0) {
    $headers = $results[0].PSObject.Properties.Name | Where-Object { $skipHeaders -inotcontains $_  }
    $markdown += "| **" + ($headers -join "** | **") + "** |$lineEnd"
    $sep = "| "
    foreach($header in $headers ) {
        ## $header.Length + 4 for the bolding of the headers
        $markdown += $sep + ("-" * ($header.Length + 4)) 
        $sep = " | "
    }
    $markdown += " |$lineEnd"
    
    foreach ($item in $results) {
        # make sure to handle nulls, and still output a | | column for them
        $row = foreach ($header in $headers) { "$($item.$header) ".Trim() }
        $markdown += "| " + ($row -join " | ") + " |$lineEnd"
    }
} else {
    $markdown = "No results found."
}

$markdown | Out-Host