Hash produces errors on strings with backslashes in Postgres

[Matt343]

Using {{ dbt_privacy.hash('my_field', salt_expr = 'my_salt') }} fails if the my_field or my_salt columns contain text with single backslashes in them. Postgres throws Postgres adapter: Postgres error: invalid input syntax for type bytea, because the macro tries to convert to bytea using a my_salt::varchar::bytea expression, which expects a string that can contain escapes. The value \xfoobar is an example of an invalid escape sequence that could be in the string, that will throw an error on this cast to bytea. The safe way to convert text to binary in postgres is something like convert_to(my_salt, pg_client_encoding()), which will handle escapes properly.