ELK logstash config statement error for mongodb input-jdbc plugin

When I see the error

SELECT count(*) AS "COUNT" FROM (db.testcaseresults.find({})) AS "T1" LIMIT 1

I think of the issuse I had this summer
https://discuss.elastic.co/t/jdbc-static-getting-a-sql-syntax-error-i-didnt-write/187844/4