Table short name and queries

It is not a super easy query.
I don't know how to properly write it in Model.

If you really like to use an alias, it seems better to extend Model to add $alias property.

If you use Query Builder, something like this:

PHP Code:

$db      = \Config\Database::connect();
$builder = $db->table('news n');
$builder->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');
$query = $builder->get(); 


See https://codeigniter4.github.io/CodeIgnit...r.html#get

ci-phpunit-test | CodeIgniter Testing Guide | CodeIgniter 3 to 4 Upgrade Helper