Hi, i need a little hint please!

in code i can find for example:

 $this->datatables
                    ->select('image, code, name, wp.quantity, alert_quantity')
                    ->from('products')
                    ->join("( SELECT * from {$this->db->dbprefix('warehouses_products')} WHERE warehouse_id = {$warehouse_id}) wp", 'products.id=wp.product_id', 'left')
                    ->where('alert_quantity > wp.quantity', NULL)
                    ->or_where('wp.quantity', NULL)
                    ->where('track_quantity', 1)
                    ->group_by('products.id');
echo $this->datatables->generate();

If i’d like to use a full query like for example:

  $this->datatables
                    ->query("SELECT a.* FROM ... ORDER BY ...");
echo $this->datatables->generate();

But i think i use a wrong syntax… Can you help my with a hint? or what kind of framework i have to check?

Thank you in advance