Controllerに直接SQLを書く方法

<?php namespace

App¥Controller use Cake\Datasource\ConnectionManager;

class HogeController extends AppController {

public function index() {

$conn = ConnectionManager::get('default');

$results = $conn->query('SELECT * FROM articles')->fetchAll('assoc');