codeigniter 4 query database code example

Example: raw query in codeigniter

$query = $db->query('YOUR QUERY HERE');