PostgreSQL-style cast operator supports SQL-style hex and binary string literals

PostgreSQL-style cast operator (::) works correctly even for SQL-style hex and binary string literals (e.g., SELECT x'414243'::String). This closes #68324. #68482 (Alexey Milovidov).