Adapters are designed to extract structured data from various sources, such as arrays, database results, or APIs, and convert them into table components. However, adapters have inherent limitations:
1. Fixed Data Structure
Adapters map data based on a predefined structure. If the original data source lacks a required field or has an inconsistent format, the adapter cannot modify it.
2. No Custom Logic
Adapters do not modify or manipulate the dataset beyond structuring it for table use.
3. Limited to Source Capabilities
If an adapter processes a MySQL result set, it cannot fetch additional fields that were not included in the query.
4. Static Column Definitions
Adapters typically extract columns as they appear in the data source and do not allow dynamic column manipulation.
These limitations introduce the need for Middleware, which provides flexibility by allowing transformations on the data before rendering.