#!/usr/bin/perl
my $str = "'SELECT * FROM TABLE WHERE COLUMN = \\'text\\'' ";
if ( $str =~ /'([^'\\]*(?:\\.[^'\\]*)*)'/ ) {
}
IyEvdXNyL2Jpbi9wZXJsCiAKbXkgJHN0ciA9ICInU0VMRUNUICogRlJPTSBUQUJMRSBXSEVSRSBDT0xVTU4gPSBcXCd0ZXh0XFwnJyAiOyAKIHByaW50ICIkc3RyXG4iOwppZiAoICRzdHIgPX4gLycoW14nXFxdKig/OlxcLlteJ1xcXSopKiknLyApIHsKCXByaW50ICIkMVxuIjsKCX0=