2 ms·
You are missing what I said. I know that from the interpreter's standpoint, it doesn't matter which one is written first. What I meant is that as a human, if
by iLoveOncall 3y ago
You are missing what I said.
I know that from the interpreter's standpoint, it doesn't matter which one is written first.
What I meant is that as a human, if you have to think first of the columns you want to bring in, it will guide you towards the joins that you need and only those, rather than thinking "let me join all those tables because I need _some_ data from the entities inside".
My point about "autocompletion is still position" was not connected to the first part of my comment.
- xboxnolifes 3y agoEven if I know the exact query I want to write, your suggestion does nothing to improve autocomplete for typing it in.
- iLoveOncall 3y agoYes because that's not the main point of my comment. Disregard completely the part about autocomplete if you want. I just added it as a separate point, to say "you can have autocomplete no matter the order in which you write your query"...