$big_query = "select FIELDMATCH from foo where bar='baz' and ...";
...
($name_query = $big_query) =~ s/FIELDMATCH/name/;
...
($node_query = $big_query) =~ s/FIELDMATCH/node/;
...