Query single result

Hello,

In CI 3 you could just do a call like $this->db->get()->result() to retreive a single result on where clause. But in CI 4 this is not available anymore (or think so) is there anyway to do this?

I'm on my phone so please excuse the brevity. 

$db->get()->getResultArray();. //or similar. 

Method chaining is explained in the CI4 docs