fix: don't treat \ as escape in standard strings, support E-strings, support vars after ->> operator

[ephys]

Pull Request Checklist

• Have you added new tests to prevent regressions?
• Does yarn test or yarn test-DIALECT pass with this change (including linting)?
• Is a documentation update included (if this change modifies existing APIs, or introduces new ones)?
• Did you update the typescript typings accordingly (if applicable)?
• Does the description below contain a link to an existing issue (Closes #[issue]) or a description of the issue you are solving?
• Did you follow the commit message conventions explained in CONTRIBUTING.md?

Description Of Change

Closes #14693

This PR fixes injectReplacements and mapBindParameters to support:

• "standard conforming strings", aka strings in which \ cannot be used to escape '
• Postgres' E-prefixed strings (escape strings), which support \-based escaping, even if standardConformingStrings is true
• Parsing bind parameters and replacements after the JSONB -> & ->> operators

As a result, these two methods will now throw if the SQL includes unterminated string literals.

It was painful to test that one dialect threw (because it did not support \ escaping), and another did not, so I introduced a new expectPerDialect utility based on expectsql

Here is such an example:

I also expanded expectsql to accept a combination of dialects separated by a space as the key, to reduce duplication (mainly for mysql/mariadb). e.g. the following is now possible:

expectsql({
  default: 'SELECT ...',
  'mysql mariadb': 'SELECT ...',
})

[WikiRik]

Do we need a similar PR for v6?

[ephys]

Yep! I'll need to backport this :)

[ephys]

Adding an extra fix

[WikiRik]

Looks good! Few small questions

[tomquist]

Shouldn't this also check for lowercase 'e'?

[ephys]

Yes it should! Thanks for double checking :)

[github-actions]

🎉 This PR is included in version 7.0.0-alpha.15 🎉

The release is available on:

• npm package (@release-v7 dist-tag)
• GitHub release

Your semantic-release bot 📦🚀

[WikiRik]

@sdepold you mentioned you wanted to backport this to v6 (together with #14733 ). Did you work on that already? Might be a nice PR to make for hacktoberfest

[sdepold]

Hey. Didn't have the time so far. Looking at this pr I got the impression that it was rather tricky but given that it's mostly a matter of replicating things, sure why not :)