Custom connection managaer query in cakephp 3

1

In older version for cakephp 1.3 ,when using custom query like below I was getting result in array of defined model or table name, like below
$query = "SELECT survey_responses . created , survey_question_options . name FROM survey_responses LEFT JOIN survey_question_options ON survey_responses . id = survey_question_options . survey_response_id ";
$res = $this->ChallengeResponse->query($query);
result is
Array
(
[0] => Array
(
[‘survey_responses’] => Array
(
[created] => 2020-04-17 07:10:52
)
[‘survey_question_options’] => Array
(
[name] => ‘test’
)
)
[1] => Array
(
[‘survey_responses’] => Array
(
[created] => 2020-04-18 07:10:52
)
[‘survey_question_options’] => Array
(
[name] => ‘test2’
)
)
)

but using connection manager in cakephp 3.x I am getting result like below

Array
(
[0] => Array
    (
        [created] => 2020-04-17 07:10:52
		[name] => 'test'
	)

[1] => Array
    (
        [created] => 2020-04-18 07:10:52
		[name] => 'test2'
	)
)
2

Please share the CakePHP 3.x code that you’re using.

3

In 3.x i am using like below
$this->conn = ConnectionManager::get(‘default’);
return $this->conn->query($sql)->fetchAll(‘assoc’);

in 1.3 I was using like below
return $this->Model->query($sql);

$sql is same in both, but gives result like i mentioned above