TFDTable, TFDQuery, and TFDStoredProc provide a dataset interface to data retrieved from a database system, each with some peculiarities. They are obviously very common components in data-centric applications, together with TFDCommand, which can be used to execute SQL statements and is largely used in the implementation of FireDAC adapters (the intermediate objects that translate dataset-like operations to SQL-like statements).
All the typical functionalities, such as master/detail mechanisms, macros and parameters, cached update support, local filtering and sorting capabilities, metadata retrieval, persistence capabilities, aggregates, and advanced functionalities such as the LocalSQL technology, are available to all FireDAC datasets (TFDTable, TFDQuery, and TFDStoreProc). Some of them are also available for TFDMemTable and TFDCommand (which slightly diverge from the other components).
We will cover some...