package App; use App::Queries qw( get_query_hash ); use SQL::Template qw( load_query_hash get_query ); load_query_hash( get_query_hash() ); my $simple_query = get_query( 'get_reprocessing_list' ); my $input = { extract => 'productTypeID' }; my $complex_query = get_query( 'get_blueprintTypeID', $input ); print "$simple_query\n$complex_query";