Is there any better Static Filter documentation yet?

I occasionally have to write new views for our ticketing list and can't seem to find any documentation for the static filters beyond this ->
Specifically, I'm looking for a syntax guide.

That is useful to a point but I'm not sure what the syntax is if I'm trying to do something like
title like "%battery%". The syntax and operators, and things like that aren't discussed.

I also found another unofficial one that has some links to some things but is difficult to navigate. Is there somewhere that someone who knew nothing about how the filters work could go to to learn to create static filters for views? Or perhaps a cheat sheet for things like this? I've written for quite a few of these but sometimes I just need a little guide for the specifics.