See this thread. I realize you may not have control of it, but mixed case names in Postgres are a terrible idea. Your query contains both single and double quotes, so depending on whether you surround the entire query with single or double quotes you will need to escape the other type of quotes in a way that both logstash and the JDBC code un-escapes them to the right level. I have no idea how to do that.
If SQL allows double quotes around the 2024-03-05 it might be easier.