Hi,

I would like to add custom product category specific attributes to products. It would be very similar to an EAV system, but I DON'T need this for Magento Integration. It is for custom parametric searches in products.

For this i need a rather fast or optimized searchable EAV extension to product table. I looking first to the JSONB field in the postgresql backend because it is a primary candidate for such feature.
Is there any possibility to implement this using the Odoo v8 ORM framework (even when for this one needs to use raw SQL queries) ?

If not. Is there any tips or clues how to implement a product category tied attribute set definition, which can be effectively used to parametric product searches?

Thanks a lot