Add Support for Pushing Down LIMIT in Distributed Queries

Why it matters

This feature optimizes distributed query performance by applying LIMIT constraints directly on remote shards before data is sent back to the initiator node. It reduces data transfer volume and speeds up query execution.

How to use it

Users can benefit from this feature automatically when executing distributed queries with LIMIT clauses. No additional configuration is required to enable limit pushdown.