3 ms·
Not sure if anyone from the Malloy team is going to read this comment, but if so then please add a dedicated comparison page between equivalent SQL and Malloy c
by summerlight 5y ago
Not sure if anyone from the Malloy team is going to read this comment, but if so then please add a dedicated comparison page between equivalent SQL and Malloy codes, especially for complex queries. That will do more PR works than 100 pages of detailed introductory materials.
From technical documentations, I can see some potentials for significant simplifications on complex analytical queries but most people don't have such time or interest on new languages.
- reilly3000 5y agoIf this is what I think it is, that wouldn’t be pretty. I used looker heavily a few years ago and its generated SQL is pretty gnarly. Imagine a wall of COALESCE( COALESCE( COALESCE(…
- ltabb 5y agoThanks, that is reasonable feedback. We'll work on updating the documentation. Here is an example of Malloy solving today's worlde in 50 lines of Malloy https://looker-open-source.github.io/malloy/documentation/examples/wordle/wordle219.html https://looker-open-source.github.io/malloy/documentation/ex... And here is the equivalent SQL. https://gist.github.com/lloydtabb/32f46e7ecbb2da1a443d1adbe9bffa24 https://gist.github.com/lloydtabb/32f46e7ecbb2da1a443d1adbe9...
- hitekker 5y agoIs it actually equivalent? I know the SQL is compiled from Malloy but I imagine the handwritten version, with comments, would look better in comparison.
- seanhunter 5y agoI've certainly done plenty of complex sql querying in my time, but I don't think making nice-looking code for solving wordle bears much relation to normal analytical sql workflows.