I use URP.
I have a shader graph, that is setup as opaque surface type and “Allow Material Override” checked.
Also, I have a material, where surface type is overridden to transparent.
And I can observe, that this material is transparent only in the scene view, but not in game or build.]