I don't want to learn your query language (2018)

> I just want my SQL back. It's a language everyone understands, it's been around since the seventies, and it's reasonably standardized. It's easy to read, and can be used by anyone, from business people to engineers. I rely a lot on SQL and in general advocate for it, but that’s too simplistic of a view IMHO. SQL makes it easy to write and read simple queries, and ridiculously complicated and arcane to write slightly more complex logic. More than…

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. Lucene for example doesn'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. Same with Splunk, it addresses a…

I don’t agree. SQL gets pretty bad in some places, such as recursive common table expressions. I also hate writing x twice in SELECT x,COUNT(*) FROM y GROUP BY x I know you can write GROUP BY 1 but that makes me feel a little dirty. The SQL specification itself is poor and different SQL dialects have different type systems so that complex queries aren’t really portable between Oracle and Microsoft SQL server. Potentially you can do SQL at multiple…

Custom query language rings to me of overfitting. "It could work just great on the global language, but wouldn't that 5% be so much better?"