FSQL vs osquery: What are the differences?
FSQL: Search through your file system with SQL-esque queries *. Pass your query to fsql via command line argument. In general, each query requires a SELECT clause (to specify which attributes should be shown), a FROM clause (to specify the directories to search in), and a WHERE clause (to specify conditions for the files); *osquery:** Expose the operating system as a relational database (by Facebook). osquery exposes an operating system as a high-performance relational database. This allows you to write SQL-based queries to explore operating system data. With osquery, SQL tables represent abstract concepts such as running processes, loaded kernel modules, open network connections, browser plugins, hardware events or file hashes.
FSQL and osquery can be categorized as "Desktop Querying" tools.
FSQL and osquery are both open source tools. It seems that osquery with 14.4K GitHub stars and 1.74K forks on GitHub has more adoption than FSQL with 3.54K GitHub stars and 101 GitHub forks.