Anyone know what is the WHERE syntax for cli app query?

I run the following command from the cli quite often, when I’m waiting for apps to load:

app chart_release query name,status,catalog,catalog_train,human_version

I noticed the autocompletion engine offering a WHERE clause, but I can’t figure out what the systex is, and the documentation doesn’t have any exmample.

Anyone know how I can list only entries that their status is ACTIVE ?
(I know I can use grep from the shell runnign cli -c..., but I’m asking specifically about the WHERE syntax).

Thanks in advance.