10 ms·
I'm late to the party here, but as stated in other comments, dyplr / Linq etc. Compose better so you can extend a query easier. Another advantage of composable
by alexisread 6y ago
I'm late to the party here, but as stated in other comments, dyplr / Linq etc. Compose better so you can extend a query easier.
Another advantage of composable syntaxes is that you can lazily evaluate parts of a query, and combine others, which allows the equivalent of a CTE on parts of a query you need to optimise.
It's also true that SQL allows pushdown of queries to the database much easier than composable syntaxes, as SQL is usually the native language there.
As such it can make for a more exploratory syntax than say graphQL where you need to define joins at design-time.