Is it possible to search by JSONB field?

Hello Jakob!

I like to use JSONB field in some tables and search by them. For example, I have a table `products` with some required fields (like `cost`, `quantity`, `name`) and one additional JSONB field `properties` where I can push any JSON data (for TV it can be `screen_size` and for `car` it can be `wheels_size`).

I don't know is Portico have support of querying this typeof fields? For example, I need to select all products with `screen_size=15` and `product_type=TV`. How to do this in Portico?

Thank you.

The issue does not mention any files, tests, or entry points. Start by reviewing Postico's existing query and JSONB support, then determine whether filtering nested JSONB values is already possible or needs a feature. Done means documenting the supported query workflow or implementing and verifying the requested product-type and screen-size search.

Written by the indexing model from the issue text.