This is great @defensivedepth, may want to considered documenting (perhaps separately) built-in functions to identify bottlenecks in SQL from within osqueryi (eg. needless recursion/repeated table scans) eg.

EXPLAIN QUERY PLAN

and

.timer ON

Great idea, thanks @fritz