loadObjectList() returns array indexed by empty string

Question

Very simple query:

    $query = $db->getQuery(true)
        ->select('*')
        ->from('#__mail_templates')
        ->where('template_id = ' . $db->quote($this->getRowId()))
        ->where('language = ' . $db->quote($languageCode));
    $rows = $db->loadObjectList($query);

For some ungodly reason, $rows has index "", empty string. Using Joomla 4.2. I hope this is not intended behaviour??

var dump:

array(1) {
  [""]=>
  object(stdClass)#218 (14) {
    ["lang_id"]=>
    int(2)
    ["asset_id"]=>
    int(66692)
    ["lang_code"]=>
    string(5) "de-DE"
    ...

Oh, I see now that the result is not coming from the correct table even.

#message: "Unknown fetch type '8'"

Answer 1

We can improve queries with prepared statements. As example:

$query = $db
    ->getQuery(true)
    ->select('*')
    ->from($db->qn('#__mail_templates'))
    ->where($db->qn('template_id') . ' = :getRowId')
    ->where($db->qn('language') . ' = :languageCode')
    ->bind(':getRowId', $this->getRowId())
    ->bind(':languageCode', $languageCode);
    
$db->setQuery($query);
        
$rows = $db->loadObjectList();

https://docs.joomla.org/J4.x:Moving_Joomla_To_Prepared_Statements

Answer 2

Meh. Buggy line should be

$rows = $db->setQuery($query)->loadObjectList();

A warning would have been nice...