Enable PATCH Endpoint to Accept Arrays for Bulk Updates (Update Many Items with Unique Values Using Unique Key, Composite Key, or Query)

Currently, the POST endpoint supports bulk updates by accepting an array of objects, allowing many items to be created in a single request. In contrast, the PATCH endpoint does not support this functionality. It requires either multiple PATCH calls—one per item—or a single call that updates multiple items with the same values. This limitation drastically increases the number of API calls required for unique updates, impacting performance, scalability, and efficiency. Enhancing PATCH to accept arrays, like POST, would streamline bulk updates and reduce system overhead. --- Basic Example Endpoint URL: Request Payload (Array of Updates): SQL Equivalent: • The API processes each object in the array independently, applying the query filters and data updates for each specified record. --- Motivation Currently, the PATCH endpoint allows updating a single object using a query filter, but bulk updates require either multiple API calls or a single object w…