I don't want to learn your query language
Yeah I think the only way you can use plain, vanilla SQL to query a system is IF its a relational database. Most of the examples are not.. they solve different problems and have vastly different architectures under the hood.<p>Lucene for example doesn&#x27;t use SQL because its really solving a different problem - text search. Its a language dedicated to what could only be expressed using something like `LIKE` and regexes in SQL.<p>Same with Splunk, it addresses a different domain and solves different problems that cant be easily expressed in SQL.<p>Same with MongoDB.. its not a relational db. Just because there is a mapping from some SQL queries to some Mongo queries, does not mean they are identical databases.<p>The query language directly impacts the AST generated, which is necessarily tied very closely to the exact capabilities&#x2F;internals of a system. This post just feels like its based on a cursory glance of what the systems do.<p>If all Lucene had was regexes, it would not perform  much better than a SQL database throwing regexes at strings. Its precisely because the query language is finer-grained that it can be better optimized for that usecase.