3 ms·
> It’s not the syntax ... but the relational data mental model that trips people up. It is also the syntax because it does not match the actual model. Even the
by mamcx 2y ago
> It’s not the syntax ... but the relational data mental model that trips people up.
It is also the syntax because it does not match the actual model. Even the simple example `SELECT 1` shows a mismatch.
And this cascade. Because the syntax is wrong, people have big trouble with `JOINs` (that is disconnected from the idea of making `?-to-?` specifications), `group by` (that doesn't exist in SQL), aggregation logic (that is badly implemented as window functions), and bigly, the lack of composability (that has a weird band-aid called CTEs) and so on.
A mismatch between the domain and the code is always reflected in syntax.