$/ was created especially for you.

Try this:

$/ = 'SQLEND';
my $response = <$remote>;
[download]

This reads in $response everything up to the next appearance of SQLEND.

Since you want an array of lines, you'd do well to add the code

my @response_line = split /\n/,$response;
[download]