I have very amount of complex interdependent data, such as products, documents, orders. I need to make expression-builder for selecting and filtering(!) data.
I have some ways to do this
1) I can make plain editor based on SQL language. Simple text field. Nothing else. In order to do filtering I can introduce keyword such as "FILTER" But I suppose that this method is bad UI.
2) I can make 3 columns: data field, condition, value.
Using this user can write these conditions Product.Price > 20 Product.Name = "Salt"
I believe that this method is better than previous, but if I choose this way how can I make filtering?
Is there third method?