Add prefix, suffix, infix template funcs

[pinzolo]

-- template
SELECT *
FROM items
WHERE note1 LIKE /*% infix "note1" %*/''
OR note2 LIKE /*% prefix "note2" %*/''
OR note2 LIKE /*% suffix "note3" %*/''

-- translated
SELECT *
FROM items
WHERE note1 LIKE '%' || $1 || '%' ESCAPE '\'
OR note2 LIKE '%' || $2 ESCAPE '\'
OR note2 LIKE $3 || '%' ESCAPE '\'

points

• Oracle does not have default escapce char, so always use ESCAPE.
• Oracle uses '％' (full width percent) and '＿' (full width underscore) as wildcard.