Now you can create REST Sources on top of REST Enabled SQL, and abstract the SQL query from APEX components. You can also use Synchronization to download remote data to local tables, use Data Profile or Post Processing features to combine local with remote data, and use REST Catalogs to provide curated sets of SQL Queries to APEX developers.
Take APEX 22.1 for a spin on apex.oracle.com!