News for hackers. Stuff that matters.
Re:Show HN: Select Star SQL, an interactive SQL book by jrockway on Tuesday September 04, 2018 @04:10AM (#17907421)
I mean, it works either way. Once you type the column names, it can guess the table name easily.

I use DataGrip at work and it can complete the column names without knowing the table name, so it ends up not being a problem.

Re:Show HN: Select Star SQL, an interactive SQL book by dragonwriter on Tuesday September 04, 2018 @12:48PM (#17910469)
> Once you type the column names, it can guess the table name easily.

If the query is simple enough that a natural join would work and you aren't doing FROM clause aliasing (which can be useful to make reusable queries self-documenting), sure.

For more complex queries and obviously any time table or column aliasing are used, that becomes somewhere between less likely and logically impossible.