[Bug] For BigQuery, a multiline string needs to be escaped with 3 quotes instead of 1 like in default__string_literal()

[b-per]

Is this a new bug in dbt-bigquery?

• I believe this is a new bug in dbt-bigquery
• I have searched the existing issues, and I could not find an existing issue for this bug

Current Behavior

dbt.string_literal(val) is defined in dbt-adapters but not overwritten in dbt-bigquery.

Calling dbt.string_literal(val) fails in BigQuery when val contains newline characters. This is because strings with newlines characters need to be "triple-escaped" in BigQuery (docs)

Expected Behavior

Calling dbt.string_literal(val) in BigQuery should work with a val containing newlines

Steps To Reproduce

Create a model with

select {{ dbt.string_literal('my multiline 
string') }} as test

Relevant log output

No response

Environment

No response

Additional Context

No response