Add Boolean Functionality To Filter Operation (in yaml schema definition)

[Ochibobo]

I've been working with the Aleph Schema on yaml files with ftm(cli) in the past month and I think it's fit if you add boolean functionality (if not present) to the Filter operation and allow it to span mutliple columns.

Currently, I've seen that among the supported operations are:

filter and filter_not

And apparently, they work for single columns. Listing multiple columns has no effect on all columns listed after the first one (correct me if I'm wrong).

The proposed functionality will have something like this:

  filter_and:
    columnA: "FilterClauseA"
    columnB: "FilterClauseB"

This filters each row entry based on the stated criteria from columnA, columnB, columnC,......, columnN. Returned rows must meet all stated criteria per column. Just like an AND operation.

  filter_or:
    columnA: "FilterClauseA"
    columnB: "FilterClauseB"

This filters each row entry based on the stated criteria from columnA, columnB, columnC,......, columnN. Returned rows should meet at least one stated criteria per column. Just like an OR operation.

IMO, the schema definition on yaml files (like a DSL) is one of the interesting features in FtM/Aleph. I don't know if the proposed features exist, if not, it seems fit for them to be added to improve the DSL's flexibility and reduce dependency on writing extra code.

[Ochibobo]

Given that this issue is being handled by #373, I'm going to close it.