Add WHERE clause into JDBC source connector config

[pMan]

Hello,

I know how various modes work with a WHERE clause appended to table/query param, but I cannot think of any strong opinion as to why filtering option on some other columns at source is not an option in the config.

I can probably contribute if it makes a good feature.

[pMan]

query.suffix property can be used to add the where clause.

The auto-generated query adds a WHERE clause as well as an ORDER BY. query.suffix is appended to the generated query after ORDER BY, so query.suffix can't be used for adding WHERE clause. Also, query.suffix is added for a different purpose.

[szalapski]

FYI, this touches on what you seem to want to do with a different approach: #1041

[pMan]

FYI, this touches on what you seem to want to do with a different approach: #1041

Thanks szalapski. And I have some code changes that work for me, and created a pull request, too.

[szalapski]

What PR?

[pMan]

What PR?

Here is the link - #1030