I currently use this to get the latest comment on each page:

$dbr = wfGetDB(DB_SLAVE);
$res = $dbr->select(
    ['Comments', 'page'],
    ['Comment_Page_ID', 'Comment_Date', 'Comment_Text'],
    'page_id IS NOT NULL',
    null,
    ['ORDER BY' => 'Comment_Date DESC'],
    [
        'page' => [
            'LEFT JOIN', 'Comment_Page_ID = page_id',
        ],
    ]
);

But it would be cleaner to have an API.
Would you be interested in a patch that adds an API for that?

Hi! My apologies for the late response, but I greatly appreciate your contribution! You can learn how to submit patches yourself by reading some of the following stuff:

• https://www.mediawiki.org/wiki/How_to_become_a_MediaWiki_hacker
• https://www.mediawiki.org/wiki/Gerrit/Tutorial (or read the quicker version: https://www.mediawiki.org/wiki/Gerrit/Getting_started )
• https://www.mediawiki.org/wiki/Special:MyLanguage/API:Main_page

Contributions are greatly appreciated as always :)