For Windows users, there is LogViewPlus. (I am the author). https://www.logviewplus.com/ It has a similar feature set (tail, syntax highlighting, SQL reporting) with a focus on accessing files remotely.
I'm the author of lnav and had never heard of logviewplus before, thanks for mentioning it. It looks like we've independently arrived at a very similar feature set, that's pretty neat. I will now shamelessly steal some of your ideas :)
I would be happy to chat to a like mind if you are interested. You can contact me here: https://www.logviewplus.com/contact.aspx
Steal away! :-)