the list rows request was set to deprecated because it caused high load on the servers. You still can use it, but it might be removed in future versions.
Why do you think that the sql query is not an alternative? If you can write the filters for the list rows, why can you not write the query? The sql-query offers many functions that should allow you to write one query. Have a look at this link: https://seatable.github.io/seatable-scripts/python/function/
Here is what I would try: (this query is not tested…)
SELECT Names, checkINStatus, Dates
WHERE Names = "John"
AND Dates = today()
AND checkINStatus = true