I have a short and quick question regarding the feasability of selecting a subquery that exists within a view.
Say I have a view that contains a subquery using a "with as" select, like:
create or replace view my_view as
with subquery as (
select * from table)
select something... view logic continues...
Is there some way to select the subquery outside of this view, to re-use the definition of the subquery without copy-pasting it? I see an obvious alternative to have the subquery used in the view as a stand-alone view, and then implementing this other places as needed - but just to clarify, I'd like to know if there exists alternatives.
