Creates a Mode from the given DbType.
Finds a Mode by its string value (case-insensitive). Handles both URL values (MySQL, PostgreSQL, etc.) and INFORMATION_SCHEMA values (Regular).