pdo_pgsql: question marks seen as parameter placeholders in dollar-quoted string

[outtersg]

Description

Dollar-quoting is a PostgreSQL way of quoting strings, and "no characters inside a dollar-quoted string are ever escaped" (see the official docs).

pdo_pgsql however sees ? as parameter placeholders (and replaces them with $1, $2, etc., when not emulating prepares which is the default mode).

See attached test case bug14244.phpt

PHP Version

PHP 8.2.1

[outtersg]

As seen in SO "How to prevent PDO from interpreting a question mark as a placeholder?", there exists workarounds.
However:

• doubling the ?s makes the SQLs PDO-specific
• ATTR_EMULATE_PREPARES is counter-intuitive, because "emulating" means "an additional layer between high- and low-level", while we just want "removing any intermediary layer to push our SQL as raw as possible to the DB".

Another thought that complicates solving :-\ is that any solution that would remove the undesired translation would break the SQL of people relying on the first workaround.

So maybe this will end in a "Won't fix", but with a clarification on the doc stating which combination of options (ATTR_EMULATE_PREPARES) will give pdo_pgsql the most direct-to-DB behaviour (and what to expect regarding other surprises. Perhaps a big table listing snippets of SQL, and for each combination of options what SQL gets effectively passed to the DB).

[MorganLOCode]

This is somewhat on the radar as a side-effect of this:
https://wiki.php.net/rfc/pdo_driver_specific_parsers
with a bit of discussion on the mailing list which may provide some food for thought.

[outtersg]

As #14035 has been merged, this issue can be considered resolved.

any solution that would remove the undesired translation would break the SQL of people relying on the first workaround.

… Aaaaand #14035 includes a nice deprecation notice that will gently alert without breaking. Yay!

Thank you @mbeccati!