Table short name and queries

Query Builder can use alias (short name).
https://codeigniter4.github.io/CodeIgnit...ilder.html

PHP Code:

$db      = \Config\Database::connect();
$builder = $db->table('users u'); 


Thanks for the tip, but it doesn't appear to work for me. Is it because I am using a different style of query building? This is the only way I have ever done queries, so maybe what I originally learned was wrong?

This query:

PHP Code:

$this->newsModel = new \App\Models\NewsModel();
$records = $this->newsModel 
    ->table('news n')
    ->select('n.id, n.title, n.created_at, n.is_active, u.firstname')
    ->join('users u','news.createdby_id = u.id','left')
    ->orderBy('is_active DESC, title ASC')
    ->findAll(); 


Produces an error:

PHP Code:

Unknown column 'n.id' in 'field list' 


While this query:

PHP Code:

$this->newsModel = new \App\Models\NewsModel();
$records = $this->newsModel 
    ->from('news n')
    ->select('n.id, n.title, n.created_at, n.is_active, u.firstname')
    ->join('users u','news.createdby_id = u.id','left')
    ->orderBy('is_active DESC, title ASC')
    ->findAll(); 


Produces this (which is obviously wrong):

PHP Code:

SELECT `n`.`id`, `n`.`title`, `n`.`created_at`, `n`.`is_active`, `u`.`firstname`
FROM (`news`, `news` `n`)
LEFT JOIN `users` `u` ON `news`.`createdby_id` = `u`.`id`
ORDER BY `is_active` DESC, `title` ASC 


In case it matters, here is the Model:

PHP Code:

namespace App\Models;

class NewsModel extends \CodeIgniter\Model
{
protected $table = 'news';

protected $allowedFields = [
 'title','article','url','is_active','createdby_id','updatedby_id','img_name'
 ];

} 


This is a super simple query, figured that was best for testing/demonstration purposes. Where have I gone wrong? Am I using an old coding style or something?