How to get the information of a product

Is there a way to retrieve all the information related to a single product ? I checked hikashop's API but it seems that this feature is not supported.
Is there a way to create a filter and retrieve all items that share determined single value ?

If you want to load the information of a product, you can do like that:
$productClass = hikashop_get('class.product');
$product=$productClass->get($product_id);

If you want to load the products based on some conditions, you will have to do a MySQL query.