Filtering out unneeded / known-good data is a key component to security operations – this handout guides you through the use of the most common SQL filtering operators that you can use with osquery.
Download here –> https://defensivedepth.files.wordpress.com/2020/04/osquery_sql-filtering.pdf
Defensive Depth 