Directory-based data distribution offers the same support as other data distribution methods for regular DMLs and queries run on the shard with partition pruning support.