Double quotes accepted unexpectedly for literal value escape in SQLite

Description

discovered in https://github.com/doctrine/dbal/pull/6325#issuecomment-1977604443

Currently PHP pdo_sqlite (and sqlite3) extensions accept SQL queries /w format that is natively not supported by SQLite degrading our testing quality as such SQL queries cannot be executed outside PHP.

PHP repro: https://3v4l.org/lfZSq

SQLite/native repro: https://dbfiddle.uk/D0hu63uV (reproducible also on https://sqlite.org/fiddle/)

Current behaviour:

" (double quote) accepted for literal value escape

Expected behaviour:

SQLite does not accept " (double quote) natively for literal value escape, I would expect the same from PHP by default, ie. fail with SQLite parse error if some query like select "-1" is executed.

PHP Version

any

Operating System

any