Heterogeneous queries

Heterogeneous queries

Hello,

Does it exists a way  to do Heterogeneous queries, off course on Firebird Dabases + TMemDataSet (= really powerful), like it is possible to do it with Firedac ?
https://docwiki.embarcadero.com/RADStudio/Rio/en/Local_SQL_(FireDAC)