News for hackers. Stuff that matters.
Re:CTEs as Lookup Tables by acjohnson55 on Wednesday January 11, 2023 @10:35PM (#34348862)
In the last example, it seems like it would be nice for the DB to let you omit the `SELECT * FROM` part.
Re:CTEs as Lookup Tables by TylerE on Thursday January 12, 2023 @01:41AM (#34350006)
In any non trivial code select * is a code smell anyway. Thus parsers don’t spend cycles looking for forms that are unlikely to be useful in real code.