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

Ok, thanks for taking a look.

My comment about it being super simple I guess was in reference to others that I have with 3 joins and 2 sub-selects with grouping and sorting (for instance)!