The simplest solution that springs to my mind is to store the SQL-compatible patterns and do a simple search-and-replace to translate them into Perl regex as needed. If there are truly only 2 different matching chars (equiv to .* and .?), this is a fairly trivial task.