I have this long and involved query that I need to use for many tasks. Currently I copy and paste the top part of the query. Unfortunately there are now many versions. I want to park the query in one location and reference it from my other queries.

Does Datagrip provide a way for me to do this?

Here is the form of my query:

with loc_remap as (

/*This select statement is long and involved and I sometimes make fat fingered mistakes. It also is useful in many queries and I want to put it in a file where it is available but out of the way. */
select * from locations

)

/*This select statement can vary and I want it in my active file.*/

select * from loc_remap

Thanks,
Matt