Query another query by passing a parameter

When I'm querying query_456 from query_123, it would be great to be able to add a parameter to query query_456 that can be selected from query_123. Something like select * from query_456_{{parameter}}