anyone happen to have found an OSQuery specific syntax guide?

What do you mean? Osquery is SQL like syntax. If you to their repo and packs, you have a lot of good (and great) examples