So for ad hoc queries a SQL query to another platform would be perfect. For use cases that require more logic, transformations are of course necessary, but here too the approach helps by eliminating the need for integration tools. Google has today, for example, even provided a new feature with which I can solve such things, for example, completely via views:

https://christianlauer90.medium.com/google-launches-materialized-view-for-biglake-12a24c81fcd2