internal/functions/Get-SupportedSiemFromDb.ps1

function Get-SupportedSiemFromDb {

<#
    .SYNOPSIS
    Returns all SIEM systems which are supported by sigma.
 
    .DESCRIPTION
    Returns all SIEM systems which are supported by sigma.
 
    .EXAMPLE
    Get-SupportedSiemFromDb
 
    Returns all SIEM systems which are supported by sigma.
 
#>


    $query = "select name from sigma_supportedSiem order by name;"

    $siemNames = Invoke-SqliteQuery -Query $query -DataSource $database | Select-Object -ExpandProperty name

    return $siemNames
}