Upsolver SQLake makes building a pipeline for data in motion as easy as writing a SQL query. New pricing of $99/TB for data ingested as well.

Airbnb has open sourced Airpal, the tool it built to help employees get to data they need to use. It's built on Facebook's open source Presto SQL engine.

An alternative - again, if supported - would be to create a view that works the same as the derived table, and use this in your query instead.