Asset query service - JSON

[galanisd]

Bug Report

Describe the Bug

Asset query service does not work in all cases when the property_value is a JSON.
See example in #3416

Expected Behavior

See #3416

Observed Behavior

See #3416

Steps to Reproduce

See #3416

Context Information

Add any other context about the problem here.

• Used version -> EDC v0.2.1

Detailed Description

See #3416

[github-actions]

Thanks for your contribution 🔥 We will take a look asap 🚀

[arnoweiss]

I've observed the same behavior.

[ndr-brt]

I think the best way to solve this would be to switch the asset properties from the dedicated table we have to a properties and privateProperties json column in the asset table, this way we would enable querying nesting objects.

Currently a maybe good enough workaround would be to use the LIKE operator, as the json is serialized as a string.