Is there a way to drop this "handcrafted" query to the SQLObject and
get the result?
 

I think you can use Prestashop._connection.queryAll("SELECT ...")

~Sean