Virtual Data Access Components
Virtual Data Access Components (VirtualDAC, formerly known as VirtualTable), is a library of components that extends data processing capabilities in Delphi and C++Builder including Community Edition on Windows, Linux, macOS, iOS and Android for both 32-bit and 64-bit platforms. VirtualDAC consists of components that allow creating in-memory data storage and executing complex SQL queries to in-memory tables when developing Delphi applications.
VirtualQuery
The TVirtualQuery component is used to retrieve data with SQL queries from sources that are any TDataSet descendants. Due to this, you can build complex SQL queries to Delphi in-memory data (data sources are TVirtualTable, TVirtualDataSet or another TVirtualQuery) or to data stored in different RDBMS'es (data sources can be TUniQuery, TOraQuery, TMSQuery, TMyQuery, etc. at the same time).