DataController.php

        $model = new UserModel();
        $model = model('UserModel');
        $model = model(UserModel::class);

        $result = $model->select('name, role')->findAll(); //array
        d($result);

        $result = $model->select('name, role')->where('id', $id)->first(); //single
        d($result);

        $result = $model->select('name, role')->find($id); //single
        d($result);

        // --- Using Query Builder ---
        $db = db_connect('default'); //jika kosongkan akan guna default juga
        $builder = $db->table('users');

        $result = $builder->select('name, role')->get()->getResult(); //array
        d($result);

        $result = $builder->select('name, role')->where('id', $id)->get()->getRow(); //single
        d($result);

        // --- Using Raw Query ---
        //binding ?
        $result = $db->query("SELECT name, role FROM users")->getResult(); //array
        d($result);

        $result = $db->query("SELECT name, role FROM users WHERE id = ?", [$id])->getRow(); //single
        d($result);

        //binding name
        $result = $db->query("SELECT name, role FROM users")->getResult(); //array
        d($result);

        $result = $db->query("SELECT name, role FROM users WHERE id = :id:", ['id' => $id])->getRow(); //single
        d($result);

        //using rawql() untuk select dan join. model dan query builder
        $caseSql = 
            new RawSql("
                    CASE 
                        WHEN name = 'admin' THEN 'urusetia'
                        WHEN name = 'user' THEN 'pengguna'
                        ELSE 'pengguna'
                    END AS role_label
            ");

        $result = $model->select(['name', $caseSql])->findAll();;
        d($result);

        $result = $builder->select(['name', $caseSql])->get()->getResultArray();
        d($result);