KDE Plasma Widget for external monitor brightness adjustment(github.com)

    SELECT
        regexp_replace("name", ' \(\d+\)$', '') AS name,
        count(ddc) working_ddc_count,
        connection,
        "DisplayProductID",
        "isHiDPI"
    FROM
        displays
    WHERE
        ddc
        AND NOT "kCGDisplayIsVirtualDevice"
        AND NOT "isAirPlayDisplay"
        AND NOT "isTV"
        AND "DisplayProductID" != 0
        AND "DisplayVendorID" NOT IN(7789, 1552) -- Filter out LGs as they don't have a useful name and Apple displays
            AND name NOT LIKE 'Unknown Display%' -- Filter out those in a semi-connected state
        GROUP BY
            name,
            "DisplayProductID",
            connection,
            "isHiDPI"
        ORDER BY
            working_ddc_count DESC;