Malloy – A Better SQL, from Looker

Re:Malloy – A Better SQL, from Looker by phonebucket on Monday January 24, 2022 @04:42AM (#30055323)

> All these languages that compile to SQL seem to forget one fundamental problem, when this stuff fails (queries becomes slow etc). We are left to debug auto-generated SQL, which is a complete nightmare..

My first inclination when hitting slow malloy (if I ever were to use it) wouldn't be to look at the auto-generated SQL, but to analyze a query plan directly, much like I would be doing for a slow SQL query.

[ Parent | on HN ]

Re:Malloy – A Better SQL, from Looker by bjarneh on Monday January 24, 2022 @07:23AM (#30056778)

> but to analyze a query plan directly

What query plan? The one belonging to the auto-generated SQL? Then fiddle with Malloy in hopes of it writing better SQL to avoid the bottlenecks?

[ Parent | on HN ]

Re:Malloy – A Better SQL, from Looker by Anon_Admirer on Monday January 24, 2022 @07:35AM (#30056867)

The auto-generated SQL from Microsoft's DAX Language for Analysis Services and PowerBi is not bad. I think it comes down to how well developed the expression engine converts to SQL. Microsoft though has had many years fine tuning their expression engine (Vertipaq). It may take a while to develop a competant engine.

[ Parent | on HN ]