AnyDAC
Example
Filtering Records
See the following demos for additional details:
AnyDAC\Samples\Comp Layer\TADQuery\Filter
AnyDAC\Samples\Comp Layer\TADMemTable\MasterDetail