set operation editor as a graph

[dridk]

Using nodeeditor, arrange table and set operation ! VariantSet and Operation (Intersect, union, except) can be joined together as node

[dridk]

I tried https://github.com/LeGoffLoic/Nodz , and it seems good for our usage. Following is a mokup suggestion and explanation of how it works

Nodes

Node refer to variant table or selection. By defaut there is only one node "variants" and it is not editable . Each node have input and output. You can edit node as a "filter node". In this case, node takes "from" attribue as input. You can edit the "where" clause from the node. You can edit node as a "set operation node". In this case node takes 2 inputs ( from1 and from2 ) . You can edit the set operation between two table.

The mokup bellow can be write in VQL as follow :

CREATE maman FROM variants WHERE ... 
CREATE papa FROM variants WHERE ... 
CREATE A FROM maman WHERE ... 
CREATE denovo = A + B