If specified, the query to perform to select new or updated rows. Use this
setting if you want to join tables, select subsets of columns in a table, or
filter data. If used, this connector will only copy data using this query–
whole-table copying will be disabled. Different query modes may still be used
for incremental updates, but to properly construct the incremental
query, it must be possible to append a WHERE clause to this query (that is–no
WHERE clauses may be used). If you use a WHERE clause, it must handle
incremental queries itself.
SELECT * FROM (SELECT * FROM table_name WHERE ID_NUM > 123) AS table_name;