Updates to case sensitive matching for compatibility with MySql & PostGres

Previously the case sensitivity was being ignored when not using a regex rule. This adds handling of case insensitive rules for both MySQL and Postgres which treat string comparison case sensitivity differently by default.