I had the same problem and I solved it by putting an extra select statement around the query.
Original
SELECT
f.id, f.bar_id, f.name, b.value, f.modified_timestamp
FROM foo f
LEFT JOIN bar b -- bar has modified_timestamp also!!!
ON f.bar_id = b.id
{{WHERE $rising_column$ > ?}} -- f.modified_timestamp
;
My solution:
select * from (
SELECT
f.id, f.bar_id, f.name, b.value, f.modified_timestamp as RisingColumnPar
FROM foo f
LEFT JOIN bar b -- bar has `modified_timestamp` also!!!
ON f.bar_id = b.id
) X
{{WHERE $rising_column$ > ?}}
In Tail Input Settings : set "Rising Column" to RisingColumnPar
... View more