Escape quotes correctly when using psql via docker in bash

docker compose exec site bash -c 'PGPASSWORD=***** psql -Ufoo -d bar \
  -h example.com -x -c "select qux, date(xyzzy) from tabley          \
  where field in(1, 2, 3) and that_time > '"'"'2024-11-18'"'"'       \
  order by that_time;"'

Quoteception

'"'"' is the Quoteception operator.

When used in the middle of a single quoted string, it:

• ' Ends the current single quoted string
• " Starts a new double quoted string
• ' That contains one single quote
• " Ends the double quoted string
• ' Re-starts the next single quoted string

Example usage:

echo 'Embedded single quote is here: '"'"' did you see it?'

Outputs:

Embedded single quote is here:  '  did you see it?