zlacker

[return to "Google's new pipe syntax in SQL"]
1. rileym+jV9[view] [source] 2024-08-28 22:57:08
>>heyden+(OP)
Is there research on what is easier to read when you are sifting through many queries?

I like the syntax for reading what the statement expects to output first, even though I agree that I don’t write them select first. I feel like this might be optimizing the wrong thing.

Although the example is nice, it does not show 20 tables joined first, which will really muddle it.

◧◩
2. beart+C0a[view] [source] 2024-08-28 23:50:18
>>rileym+jV9
The select list is meaningless without everything that follows. Knowing that a query selects "id, "date" tells you nothing without knowing the table, the search criteria, etc.
◧◩◪
3. rileym+Z5b[view] [source] 2024-08-29 11:52:05
>>beart+C0a
If you name fields that way, but accountId, createDate may not be meaningless in the context you are looking at.
[go to top]