News for hackers. Stuff that matters.

A comment on PRQL – A proposal for a better SQL. Parent comment

Re:PRQL – A proposal for a better SQL by taeric on Monday January 24, 2022 @04:36PM (#30064392)
500 times 50 is still not a big number. And you could do decent statistical suggestions on the current columns in.

Good intelligent suggestions is, of course, helpful. And I agree that suggesting one of 500 is easier than the other. That said, neither is hard for a computer. And even asking friends what table I want will often be done with starting with the actual columns I want.

[ Parent | on HN ]
Re:PRQL – A proposal for a better SQL by tester756 on Monday January 24, 2022 @04:38PM (#30064411)
On the other hand I don't see why it couldnt work both ways

if you start query with

SELECT MiddleName then you could receive auto complete thats adds "FROM Users" and moves your cusor after MiddleName.

if you start query with

FROM Users SELECT _ and know intellisense drops list of columns

[ Parent | on HN ]
Re:PRQL – A proposal for a better SQL by taeric on Monday January 24, 2022 @04:48PM (#30064531)
Agreed. I'm really just arguing that it doesn't have to be from first.
[ Parent | on HN ]