We looked at Log Parser before building Crab. The syntax was far from standard SQL, it didn't have joins etc. It didn't use string matching to identify subset

We looked at Log Parser before building Crab. The syntax was far from standard SQL, it didn't have joins etc. It didn't use string matching to identify subsets of files to query. And maybe the most important thing, it doesn't have the exec function to run operating system commands on the files you get back in your query results.