queryBuilder + getFieldNames

It's not working because in your first example $r is a query object that has access to the database functions. But in your second example, $r is a simple user object (can be an Entity or a standard object). 

Using your second example, you can use your model object to access the db and call getFieldNames() like this:

PHP Code:

$users = new \App\Models\UserModel();
var_dump($users->db->getFieldNames()); 


CodeIgniter 4 tutorials (EN/FR) - https://includebeer.com
/*** NO support in private message - Use the forum! ***/