So in truth Kedro isn't great at this - what we have seen people do is to define a custom SQL dataset applys a date range query and then these results are then saved in a partitioned/incremental dataset