title: Kafka Connect in timestamp mode - how to append to the end of a query?
body: <p>I have a configured source connector, retrieving from DB2 and using timestamp mode. e.g: </p>
  
  <pre><code>    "name": "my-jdbc-connector",
      "config": {
          "connector.class": "io.confluent.connect.jdbc.JdbcSourceConnector",
          "connection.url": "jdbc:db2://db2server.mycompany.com:4461/myDB",
          "connection.user: "dbUser",
          "connection.password": "dbPass",
          "dialect.name": "Db2DatabaseDialect",
          "mode": "timestamp",
          "query": "select fname, lname, custId, custRegion, lastUpdate from CustomerMaster",
          "timestamp.column.name": "lastUpdate",
          "table.types": "TABLE",
          "topic.prefix": "master.customer"
      }
  }
  </code></pre>
  
  <p>I need to use "with UR" (with uncommitted read, aka 'dirty read') as part of the select, so as not to lock the table I'm querying from. </p>
  
  <p>But, when using timestamp mode, Kafka Connect appends on to the end of the where clause, as in </p>
  
  <pre><code>where lastUpdate between '10/12/2019' and '10/14/2019';
  </code></pre>
  
  <p>DB2 requires that "with UR" be the last thing in the where clause. Does anyone know if manipulating the where clause like this is possible? I don't currently see how timestamp mode and "with UR" can coexist.</p>