It's my understanding that AGOL data is limited in ArcGIS Pro because database views and query layers are not supported.
For example, @JustinH's requirement in 1:M Join to Pull feature with Specific Attribute information (AGOL Feature Service that is hosted).
It would be ideal to dynamically query AGOL data in Pro rather than export to a file geodatabase or mobile geodatabase. An example of a dynamic query in a feature layer would be: replace values in a field on the fly—replace nulls with zeros (or zeros with nulls).
Could dynamic value replacement functionality be added to one of the existing feature layer geoprocessing tools, such as Make Query Table?