How to use 'AS' in cakephp 4 query?

Question

How to add AS in cake php query?

$table = $this
->find()
->select(['id', 'fname AS first_name'])

When i run it "check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AS "

user_1127933 · Answer

Simple try:

$this
->find()
->select(['id'])
->select(['fname' => 'first_name']); // SELECT first_name AS fname

and read: