Spice supports what DataFusion supports, which is generally yes but there is still work to do to push down more queries to TableProviders. For example, joins within a single source are not yet pushed down to the underlying provider.
You can write a single query across many data sources which is what we show in the demo on the Git repo.
You can write a single query across many data sources which is what we show in the demo on the Git repo.