I am sure this is well-known, but I cannot find a reference. Consider a cartesian square $$\require{AMScd} \begin{CD} P @>{v}>> X\\ @V{g}VV @VV{f}V \\ Z @>{u}>> Y \end{CD}$$ where all morphisms are morphisms of algebraic varieties over a field. It is known (e.g. Harthorne, III.9.3) that when $u$ is flat and $f$ is proper, there is a natural isomorphism $$u^\ast f_\ast\overset{\sim}{\longrightarrow} g_\ast v^\ast$$ of functors $Coh_X\to Coh_Z$.
Question. Is there also an isomorphism $v_\ast g^\ast\cong f^\ast u_\ast$ of functors $QCoh_Z\to QCoh_X$?
Assuming $Z$ is proper (and $Y$ separated), we can restrict attention to coherent sheaves. I am actually interested in the case when $u$ is \'etale and $f$ is a closed immersion, but I do not think this specialization is of any real help.
Thank you in advance!
I think what you are saying is (almost) true: it works in the derived category.
Below, for a scheme map $\alpha$, we denote $\alpha^*$ to be the derived functor $\mathsf{L}\alpha^*$ and denote $\alpha_*$ to be the derived functor $\mathsf{R}\alpha_*$. Also, $\mathbf{D}_\mathsf{qc}(-)$ denotes the derived category of sheaves of modules with quasi-coherent cohomology.
We adopt your notation, but generalize a bit: let $X,Y,P,Z$ be quasi-separated schemes, and suppose they fit into a commutative square $\sigma$: $$\begin{CD} P @>v>> X\\ @VgVV \sigma @VVfV\\ Z @>u>> Y \end{CD}$$ where all maps are quasi-compact and quasi-separated.
We say $\sigma$ is
In this situation, the following theorem holds:
Theorem [Lipman, 3.10.3]. The three independence conditions above are equivalent.
The proof is a bit complicated, but the idea is you want to reduce to the affine case after showing the independence conditions above are local. Lipman then proceeds by showing that these three independence conditions are equivalent to being Künneth-independent, whose definition is a bit harder to state.