I am working with a CakePHP based API that utilizes AWS Aurora to manage our MySQL database. The CakePHP application has many large read queries that that requires a separate Reader Endpoint to not exhaust the database resources.
The way this works is that AWS gives you separate endpoints to use in the host field when you connect CakePHP to it.
I went ahead and configured it the following way, which works. The folowing datasources are set up in config/app.php, using the reader and cluster (default) endpoints for the host value:

<?php

// Other data-source and app settings are omitted, to keep things simple 
return [
    'Datasources' => [
        'default' => [
            'host' => 'mydbcluster.cluster-123456789012.us-east-1.rds.amazonaws.com',
        ],
        'read' => [
            'host' => 'mydbcluster.cluster-ro-123456789012.us-east-1.rds.amazonaws.com',
        ],
    ]
];

Both the 'read' and 'default' data sources point to the same database, but so this additional data source is purely configured to support the read only host value.
At this point, all I have to do is overwrite the default connection to read on the queries that need the read connection:

<?php

/**
 * Class TaskNotesController
 *
 * @property \App\Model\Table\TaskNotesTable $TaskNotes
 */
class TaskNotesController extends \Cake\Controller\Controller
{

    public function index(): void
    {
        $taskNotes = $this->TaskNotes
            ->setConnection(\Cake\Datasource\ConnectionManager::get('read'))
            ->find('all')
            ->where(['foo' => 'bar']);
    }

}

However, I would like to apply the read endpoint to all read queries in the application. It seems like Cake would have a cleaner way of doing this, to avoid attaching the setConnection() call on every query.
Can you tell me if there is a more streamlined way of doing this in CakePHP?
Thanks in advance!