What is the best way to make requests in opencart?

Question

opencart

For example, there is a query like
$this->db->query("UPDATE " . DB_PREFIX . "product SET image = '" . $this->db->escape($data['image']) . "' WHERE product_id = '" . (int)$product_id . "'");
And I want to use normal PDO
Or is it better to do everything as it is done in tsms?

Answer 1

Naturally, everything is like in the CMS. But take a closer look at the implementation of connecting to the database. If I'm not mistaken, there are several wrappers for connecting to the database, and even PDO was planned. And if so, then you can simply choose the right driver or implement your own without breaking the application and use the functionality you need in your module.