4 ms·
>Malloy reads the schema so you don’t need to model everything. Malloy allows creation of re-usable metrics and logic, but there’s no need for boilerplate code
by SkeuomorphicBee 5y ago
>Malloy reads the schema so you don’t need to model everything. Malloy allows creation of re-usable metrics and logic, but there’s no need for boilerplate code that doesn’t add anything new.
That is the one thing that I miss in SQL. I find it extremely wasteful (developer hours) that every SQL query needs to redefine the whole relational model from scratch. The RDBM knows the model, it should use that knowledge to automate the necessary joins.
- marcus_holmes 5y agoI get this, but I prefer being explicit over less typing. I have implemented schemas in the past involving multiple routes between tables, and self-joins, and getting an engine to work all that out would be a problem. Easier to just do more typing.