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