Unity: Rendering Transparency

In the videos, it's mentioned that depth is required for all rendered pixels. Is transparency not supported?

Specifically, regarding URP shaders, is it that transparency is only supported for fully immersive? (or is it not supported at all)