Spring NamedParameterJdbcTemplate doesn't support postgresql dollar quoting $$ [SPR-16512]

RJ opened SPR-16512 and commented

When trying to use valid postgresql dollar quoting syntax, NamedParameterJDBCTemplate thinks that the dollarquote is a named param and fails b/c no value is given.

A query like:

select * from a where a.col1 = $ranS58$value$ranS58$;

throws the error:

org.springframework.dao.InvalidDataAccessApiUsageException: No value supplied for the SQL parameter 'value$ranS58$':

---

Affects: 4.3.14

Issue Links: - #20887 NamedParameterJdbcTemplate fails on PostgreSQL array - #21054 Spring JDBC not correctly processing Postgresql ? operator